Symfony Profiler

<?php
namespace App\Controller;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Component\Process\Exception\ProcessFailedException;
use Symfony\Component\Process\Process;
use Symfony\Component\Yaml\Yaml;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\Serializer\Encoder\JsonEncoder;
use Symfony\Contracts\Cache\ItemInterface;
use Symfony\Contracts\Cache\CacheInterface;
use App\Repository\ProjectRepository;
use App\Repository\RedirectRepository;
use App\Repository\DomainRepository;
use App\Repository\HttpsTypeRepository;
use App\Repository\BackendRepository;
use App\Repository\NginxTemplateRepository;
use App\Entity\Project;
use App\Entity\Redirect;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Component\Filesystem\Exception\IOExceptionInterface;
use App\Form\Type\RedirectType;
use App\Form\Type\ProjectType;
use App\Entity\Ftp;
class AdminController extends AbstractController
{
private $cache;
private $repository;
private $redirectsRepository;
private $domainsRepository;
private $https_repository;
private $backend_repository;
private $nginx_template_repository;
private $manager;
public function __construct(CacheInterface $cache, ProjectRepository $repository, RedirectRepository $redirectsRepository, DomainRepository $domainsRepository, HttpsTypeRepository $https_repository, BackendRepository $backend_repository, NginxTemplateRepository $nginx_template_repository, EntityManagerInterface $manager)
{
$this->cache = $cache;
$this->repository = $repository;
$this->redirectsRepository = $redirectsRepository;
$this->domainsRepository = $domainsRepository;
$this->https_repository = $https_repository;
$this->backend_repository = $backend_repository;
$this->nginx_template_repository = $nginx_template_repository;
$this->manager = $manager;
}
/**
* @Route("/", name="admin")
*/
public function index()
{
$soft = $this->cache->get('versions', function (ItemInterface $item) {
$item->expiresAfter(604800);
return $this->getVersions();
});
return $this->render('admin/index.html.twig', [
'controller_name' => 'AdminController',
'soft' => $soft
]);
}
private function getVersions()
{
//skip versions check before multicore support
return [];
$process = Process::fromShellCommandline('sudo /webcrate/versions.py');
$process->run();
if (!$process->isSuccessful()) {
throw new ProcessFailedException($process);
}
$soft_json = $process->getOutput();
$encoder = new JsonEncoder();
$soft = [];
if(!empty($soft_json))
{
$soft = $encoder->decode($soft_json, 'json');
}
return $soft;
}
/**
* @Route("/admin/projects", name="admin-projects")
*/
public function projects()
{
$list = $this->repository->getListForTable();
return $this->render('admin/projects.html.twig', [
'controller_name' => 'AdminController',
'projects' => $list,
]);
}
/**
* @Route("/admin/redirects", name="admin-redirects")
*/
public function redirects()
{
$list = $this->redirectsRepository->getListForTable();
return $this->render('admin/redirects.html.twig', [
'controller_name' => 'AdminController',
'redirects' => $list,
]);
}
/**
* @Route("/admin/domains", name="admin-domains")
*/
public function domains()
{
$list = $this->domainsRepository->getListForTable();
return $this->render('admin/domains.html.twig', [
'controller_name' => 'AdminController',
'domains' => $list,
]);
}
/**
* @Route("/admin/project/add", name="project-add")
*/
public function newProject(Request $request)
{
$project = new Project();
$form = $this->createForm(ProjectType::class, $project);
if ($request->isMethod('POST'))
{
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid())
{
$project = $form->getData();
$project->setUid($this->repository->getFirstAvailableUid());
$ftps = $project->getFtps();
foreach ( $ftps as $ftp ) {
$ftp->setProject($project);
}
$this->manager->persist($project);
$this->manager->flush();
$this->updateProjectsYaml();
return $this->redirectToRoute('admin-projects');
}
}
return $this->render(
'admin/project.html.twig',
[
'form' => $form->createView(),
]
);
}
/**
* @Route("/admin/project/{uid}", name="admin-project")
*/
public function project($uid, Request $request)
{
$project = $this->repository->loadByUid($uid);
$form = $this->createForm(ProjectType::class, $project);
if ($request->isMethod('POST'))
{
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid())
{
$project = $form->getData();
$ftps = $project->getFtps();
foreach ( $ftps as $ftp ) {
$ftp->setProject($project);
}
$this->manager->persist($project);
$this->manager->flush();
$this->updateProjectsYaml();
return $this->redirectToRoute('admin-projects');
}
}
return $this->render(
'admin/project.html.twig',
[
'form' => $form->createView()
]
);
}
/**
* @Route("/admin/project/{uid}/delete", name="admin-project-delete")
*/
public function projectDelete($uid)
{
$project = $this->repository->loadByUid($uid);
$this->manager->remove($project);
$this->manager->flush();
$list = $this->repository->getListForTable();
$this->updateProjectsYaml();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'projects' => $list
]);
return $response;
}
/**
* @Route("/admin/project/{uid}/activate", name="admin-project-activate")
*/
public function projectActivate($uid)
{
$project = $this->repository->loadByUid($uid);
$project->setActive(true);
$this->manager->flush();
$list = $this->repository->getListForTable();
$this->updateProjectsYaml();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'projects' => $list
]);
return $response;
}
/**
* @Route("/admin/project/{uid}/reload", name="admin-project-reload")
*/
public function projectReload($uid)
{
$project = $this->repository->loadByUid($uid);
if ( !$project->isActual() ) {
try {
$name = $project->getName();
$process = Process::fromShellCommandline("sudo /webcrate/reload.py $name");
$process->run();
if (!$process->isSuccessful()) {
throw new ProcessFailedException($process);
}
} catch (IOExceptionInterface $exception) {
$debug['error'] = $exception->getMessage();
}
}
$list = $this->repository->getListForTable();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'projects' => $list
]);
return $response;
}
/**
* @Route("/admin/reload-config", name="admin-reload-config")
*/
public function projectReloadConfig()
{
try {
$process = Process::fromShellCommandline('sudo /webcrate/reload.py');
$process->run();
if (!$process->isSuccessful()) {
throw new ProcessFailedException($process);
}
} catch (IOExceptionInterface $exception) {
$debug['error'] = $exception->getMessage();
}
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
]);
return $response;
}
/**
* @Route("/admin/project/{uid}/deactivate", name="admin-project-deactivate")
*/
public function projectDeactivate($uid)
{
$project = $this->repository->loadByUid($uid);
$project->setActive(false);
$this->manager->flush();
$list = $this->repository->getListForTable();
$this->updateProjectsYaml();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'projects' => $list
]);
return $response;
}
/**
* @Route("/admin/import-projects", name="import-projects")
*/
public function importProjects(Request $request): Response
{
$file = $request->files->get('file');
$filepath = $file['tmp_name'];
$projects = Yaml::parseFile($filepath);
foreach ( $projects as $projectname => $project_obj ) {
$project_obj = (object)$project_obj;
$entity = $this->repository->loadByUid($project_obj->uid);
if ( empty($entity) ) {
$project = new Project();
$project_obj->active = !empty($project_obj->active) ? $project_obj->active : false;
$project_obj->memcached = !empty($project_obj->memcached) ? $project_obj->memcached : false;
$project_obj->redis = !empty($project_obj->redis) ? $project_obj->redis : false;
$project_obj->solr = !empty($project_obj->solr) ? $project_obj->solr : false;
$project_obj->elastic = !empty($project_obj->elastic) ? $project_obj->elastic : false;
$project_obj->redirect = !empty($project_obj->redirect) ? $project_obj->redirect : false;
$project_obj->backup = !empty($project_obj->backup) ? $project_obj->backup : false;
$project_obj->gzip = !empty($project_obj->gzip) ? $project_obj->gzip : false;
$project_obj->mysql_db = !empty($project_obj->mysql_db) ? $project_obj->mysql_db : false;
$project_obj->mysql5_db = !empty($project_obj->mysql5_db) ? $project_obj->mysql5_db : false;
$project_obj->postgresql_db = !empty($project_obj->postgresql_db) ? $project_obj->postgresql_db : false;
$project_obj->root_folder = !empty($project_obj->root_folder) ? $project_obj->root_folder : 'data';
$project_obj->password = !empty($project_obj->password) ? $project_obj->password : 'empty_password';
$project_obj->https = !empty($project_obj->https) ? $project_obj->https : 'disabled';
$project_obj->backend = !empty($project_obj->backend) ? $project_obj->backend : 'php';
$project_obj->backend_version = !empty($project_obj->backend_version) ? $project_obj->backend_version : '81';
$project_obj->gunicorn_app_module = !empty($project_obj->gunicorn_app_module) ? $project_obj->gunicorn_app_module : '';
$project_obj->nginx_template = !empty($project_obj->nginx_template) ? $project_obj->nginx_template : 'default';
$project_obj->volume = !empty($project_obj->volume) ? $project_obj->volume : 0;
$project_obj->nginx_block = !empty($project_obj->nginx_block) ? $project_obj->nginx_block : '';
$project_obj->domains = !empty($project_obj->domains) ? $project_obj->domains : [$projectname . '.test'];
$project_obj->nginx_options = !empty($project_obj->nginx_options) ? $project_obj->nginx_options : [];
$project_obj->auth_locations = !empty($project_obj->auth_locations) ? $project_obj->auth_locations : [];
$project_obj->duplicity_filters = !empty($project_obj->duplicity_filters) ? $project_obj->duplicity_filters : [];
$project_obj->ftps = !empty($project_obj->ftps) ? $project_obj->ftps : [];
$project_obj->ip_address = !empty($project_obj->ip_address) ? $project_obj->ip_address : '';
$project->setUid($project_obj->uid);
$project->setName($projectname);
$project->setVolume($project_obj->volume);
$project->setActive($project_obj->active == 'yes' || $project_obj->active === true);
$project->setMemcached($project_obj->memcached == 'yes' || $project_obj->memcached === true);
$project->setRedis($project_obj->redis == 'yes' || $project_obj->redis === true);
$project->setSolr($project_obj->solr == 'yes' || $project_obj->solr === true);
$project->setElastic($project_obj->elastic == 'yes' || $project_obj->elastic === true);
$project->setBackup($project_obj->backup == 'yes' || $project_obj->backup === true);
$project->setRedirect($project_obj->redirect == 'yes' || $project_obj->redirect === true);
$project->setGzip($project_obj->gzip == 'yes' || $project_obj->gzip === true);
$project->setMysql($project_obj->mysql_db == 'yes' || $project_obj->mysql_db === true);
$project->setMysql5($project_obj->mysql5_db == 'yes' || $project_obj->mysql5_db === true);
$project->setPostgre($project_obj->postgresql_db == 'yes' || $project_obj->postgresql_db === true);
$project->setRootFolder($project_obj->root_folder);
$project->setPasswordHash($project_obj->password);
$project->setIpAddress($project_obj->ip_address);
$https = $this->https_repository->findByName($project_obj->https);
$project->setHttps($https);
$backend_version = empty($project_obj->backend_version) ? ( $project_obj->backend == 'php' ? '81' : 'latest' ) : $project_obj->backend_version;
$backend = $this->backend_repository->findByNameAndVersion($project_obj->backend, (string)$backend_version);
$project->setBackend($backend);
if ( !empty($project_obj->gunicorn_app_module) && ( $project_obj->backend == 'gunicorn' ) ) {
$project->setGunicornAppModule($project_obj->gunicorn_app_module);
}
$template = $this->nginx_template_repository->findByName($project_obj->nginx_template);
$project->setNginxTemplate($template);
$project->setNginxBlock($project_obj->nginx_block);
$project->setDomains($project_obj->domains);
$options_array = [];
foreach ( $project_obj->nginx_options as $name => $value ) {
$options_array[] = [ 'name' => $name, 'value' => $value ];
}
$project->setNginxOptions($options_array);
$locations_array = [];
foreach ( $project_obj->auth_locations as $location ) {
$locations_array[] = [
'path' => $location['path'],
'title' => $location['title'],
'user' => $location['user'],
'password' => $location['password']
];
}
$project->setAuthLocations($locations_array, true);
$duplicity_filters_array = [];
foreach ( $project_obj->duplicity_filters as $filter ) {
$duplicity_filters_array[] = [
'mode' => $filter['mode'],
'path' => $filter['path']
];
}
$project->setDuplicityFilters($duplicity_filters_array, true);
foreach ( $project_obj->ftps as $index => $ftp_data ) {
$ftp = new Ftp();
$ftp->setName($ftp_data['name']);
$ftp->setWeight($index);
$ftp->setPasswordHash($ftp_data['password']);
$ftp->setHome($ftp_data['home']);
$project->addFtp($ftp);
}
$this->manager->persist($project);
}
}
$this->manager->flush();
$this->updateProjectsYaml();
$list = $this->repository->getListForTable();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'projects' => $list
]);
return $response;
}
public function updateProjectsYaml()
{
$ymlData = $this->getYmlData();
try {
$new_file_path = "/webcrate/updated-projects.yml";
file_put_contents($new_file_path, $ymlData);
$process = Process::fromShellCommandline('sudo /webcrate/updateprojects.py');
$process->run();
if (!$process->isSuccessful()) {
throw new ProcessFailedException($process);
}
} catch (IOExceptionInterface $exception) {
$debug['error'] = $exception->getMessage();
}
}
public function getYmlData()
{
$projects = $this->repository->getList();
$projects_list = (object)[];
foreach ( $projects as $project ) {
$projectname = $project->getName();
$projects_list->$projectname = $project->toObject();
}
$ymlData = Yaml::dump($projects_list, 3, 2, Yaml::DUMP_OBJECT_AS_MAP);
return $ymlData;
}
/**
* @Route("/admin/redirect/add", name="redirect-add")
*/
public function newRedirect(Request $request)
{
$redirect = new Redirect();
$form = $this->createForm(RedirectType::class, $redirect);
if ($request->isMethod('POST'))
{
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid())
{
$redirect = $form->getData();
$this->manager->persist($redirect);
$this->manager->flush();
$this->updateRedirectsYaml();
return $this->redirectToRoute('admin-redirects');
}
}
return $this->render(
'admin/redirect.html.twig',
[
'form' => $form->createView()
]
);
}
/**
* @Route("/admin/redirect/{name}", name="admin-redirect")
*/
public function adminRedirect($name, Request $request)
{
$redirect = $this->redirectsRepository->loadByName($name);
$form = $this->createForm(RedirectType::class, $redirect);
if ($request->isMethod('POST'))
{
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid())
{
$redirect = $form->getData();
$this->manager->persist($redirect);
$this->manager->flush();
$this->updateRedirectsYaml();
return $this->redirectToRoute('admin-redirects');
}
}
return $this->render(
'admin/redirect.html.twig',
[
'form' => $form->createView()
]
);
}
/**
* @Route("/admin/redirect/{name}/delete", name="admin-redirect-delete")
*/
public function redirectDelete($name)
{
$redirect = $this->redirectsRepository->loadByName($name);
$this->manager->remove($redirect);
$this->manager->flush();
$list = $this->redirectsRepository->getListForTable();
$this->updateRedirectsYaml();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'redirects' => $list
]);
return $response;
}
/**
* @Route("/admin/redirect/{name}/activate", name="admin-redirect-activate")
*/
public function redirectActivate($name)
{
$redirect = $this->redirectsRepository->loadByName($name);
$redirect->setActive(true);
$this->manager->flush();
$list = $this->redirectsRepository->getListForTable();
$this->updateRedirectsYaml();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'redirects' => $list
]);
return $response;
}
/**
* @Route("/admin/redirect/{name}/reload", name="admin-redirect-reload")
*/
public function redirectReload($name)
{
$redirect = $this->redirectsRepository->loadByName($name);
if ( !$redirect->isActual() ) {
try {
$name = $redirect->getName();
$process = Process::fromShellCommandline("sudo /webcrate/reload-redirect.py $name");
$process->run();
if (!$process->isSuccessful()) {
throw new ProcessFailedException($process);
}
} catch (IOExceptionInterface $exception) {
$debug['error'] = $exception->getMessage();
}
}
$list = $this->redirectsRepository->getListForTable();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'redirects' => $list
]);
return $response;
}
/**
* @Route("/admin/reload-redirect-config", name="admin-reload-redirect-config")
*/
public function redirectReloadConfig()
{
try {
$process = Process::fromShellCommandline('sudo /webcrate/reload-redirect.py');
$process->run();
if (!$process->isSuccessful()) {
throw new ProcessFailedException($process);
}
} catch (IOExceptionInterface $exception) {
$debug['error'] = $exception->getMessage();
}
$response = new JsonResponse();
$response->setData([
'result' => 'ok'
]);
return $response;
}
/**
* @Route("/admin/redirect/{name}/deactivate", name="admin-redirect-deactivate")
*/
public function redirectDeactivate($name)
{
$redirect = $this->redirectsRepository->loadByName($name);
$redirect->setActive(false);
$this->manager->flush();
$list = $this->redirectsRepository->getListForTable();
$this->updateRedirectsYaml();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'redirects' => $list
]);
return $response;
}
/**
* @Route("/admin/import-redirects", name="import-redirects")
*/
public function importRedirects(Request $request): Response
{
$file = $request->files->get('file');
$filepath = $file['tmp_name'];
$redirects = Yaml::parseFile($filepath);
foreach ( $redirects as $redirectname => $redirect_obj ) {
$redirect_obj = (object)$redirect_obj;
$entity = $this->redirectsRepository->loadByName($redirectname);
if ( empty($entity) ) {
$redirect = new Redirect();
$redirect_obj->active = !empty($redirect_obj->active) ? $redirect_obj->active : false;
$redirect_obj->https = !empty($redirect_obj->https) ? $redirect_obj->https : 'disabled';
$redirect_obj->domains = !empty($redirect_obj->domains) ? $redirect_obj->domains : [$redirectname . '.test'];
$redirect->setActive($redirect_obj->active == 'yes' || $redirect_obj->active === true);
$redirect->setName($redirectname);
$redirect->setUrl($redirect_obj->url);
$https = $this->https_repository->findByName($redirect_obj->https);
$redirect->setHttps($https);
$redirect->setDomains($redirect_obj->domains);
$this->manager->persist($redirect);
}
}
$this->manager->flush();
$this->updateRedirectsYaml();
$list = $this->redirectsRepository->getListForTable();
$response = new JsonResponse();
$response->setData([
'result' => 'ok',
'redirects' => $list
]);
return $response;
}
public function updateRedirectsYaml()
{
$ymlData = $this->getRedirectsYmlData();
try {
$new_file_path = "/webcrate/updated-redirects.yml";
file_put_contents($new_file_path, $ymlData);
$process = Process::fromShellCommandline('sudo /webcrate/updateredirects.py');
$process->run();
if (!$process->isSuccessful()) {
throw new ProcessFailedException($process);
}
} catch (IOExceptionInterface $exception) {
$debug['error'] = $exception->getMessage();
}
}
public function getRedirectsYmlData()
{
$redirects = $this->redirectsRepository->getList();
$redirects_list = (object)[];
foreach ( $redirects as $redirect ) {
$redirectname = $redirect->getName();
$redirects_list->$redirectname = $redirect->toObject();
}
$ymlData = Yaml::dump($redirects_list, 3, 2, Yaml::DUMP_OBJECT_AS_MAP);
return $ymlData;
}
}

src/Controller/AdminController.php line 57