Symfony Profiler

<?php
namespace App\Controller;
use Doctrine\ORM\Tools\Setup;
use Doctrine\ORM\EntityManager;
use Symfony\Component\Yaml\Yaml;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Console\Input\ArrayInput;
use Symfony\Component\Console\Output\NullOutput;
use Symfony\Component\HttpKernel\KernelInterface;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Bundle\FrameworkBundle\Console\Application;
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Webkul\UVDesk\CoreFrameworkBundle\Entity as CoreEntities;
class ConfigureHelpdesk extends Controller
{
const HELPDESK_VERSION = '1.0.17';
const DB_ENV_PATH_TEMPLATE = "DATABASE_URL=DB_DRIVER://DB_USER:DB_PASSWORD@DB_HOST/DB_NAME\n";
const DB_ENV_PATH_PARAM_TEMPLATE = "env(DATABASE_URL): 'DB_DRIVER://DB_USER:DB_PASSWORD@DB_HOST/DB_NAME'\n";
const DEFAULT_JSON_HEADERS = [
'Content-Type' => 'application/json',
];
private static $requiredExtensions = [
[
'name' => 'imap',
],
[
'name' => 'mailparse',
],
[
'name' => 'mysqli',
],
];
private static $requiredConfigfiles = [
[
'name' => 'uvdesk',
],
[
'name' => 'swiftmailer',
],
[
'name' => 'uvdesk_mailbox',
],
];
public function load()
{
return $this->render('installation-wizard/index.html.twig', [
'version' => self::HELPDESK_VERSION,
]);
}
public function evaluateSystemRequirements(Request $request)
{
$max_execution_time = ini_get('max_execution_time');
// Evaluate system specification requirements
switch (strtolower($request->request->get('specification'))) {
case 'php-version':
$response = [
'status' => version_compare(phpversion(), '7.0.0', '<') ? false : true,
'version' => sprintf('%s.%s.%s', PHP_MAJOR_VERSION, PHP_MINOR_VERSION, PHP_RELEASE_VERSION),
];
if ($response['status']) {
$response['message'] = sprintf('Using PHP v%s', $response['version']);
} else {
$response['message'] = sprintf('Currently using PHP v%s. Please use PHP 7 or greater.', $response['version']);
}
break;
case 'php-extensions':
$extensions_status = array_map(function ($extension) {
return [
$extension['name'] => extension_loaded($extension['name']),
];
}, self::$requiredExtensions);
$response = [
'extensions' => $extensions_status,
];
break;
case 'php-maximum-execution':
$response['status' ] = $max_execution_time >= 30 ? true : false;
if ($response['status']) {
$response['message'] = sprintf('Maximum execution time is %s', ini_get('max_execution_time').' sec');
} else {
$response['message'] = sprintf('Please increase your max execution time.' );
$response['description'] = 'Issue can be resolved by simply<a href="https://www.simplified.guide/php/increase-max-execution-time" target="_blank"> increasing your maximum execution time</a> make it 60 or more and restart your server after making this change, refresh the browser and try again.';
}
break;
case 'php-envfile-permission':
$filename = $this->get('kernel')->getProjectDir().'/.env';
$response['status'] = is_writable($filename) ? true : false;
if ($response['status']) {
$response['message'] = sprintf('Read/Write permission enabled for .env file.');
} else {
$response['message'] = sprintf('Please enable read/write permission for .env file of your project.');
$response['description'] = ' Issue can be resolved by simply <a href="https://www.uvdesk.com/en/blog/open-source-helpdesk-installation-on-ubuntu-uvdesk/" target="_blank"> enabling your .env file read/write permission</a> refresh the browser and try again.';
}
break;
case 'php-configfiles-permission':
$configfiles_status = array_map(function ($configfile) {
return [
$configfile['name'] => is_writable($this->get('kernel')->getProjectDir().'/config/packages/'.$configfile['name'].'.yaml') ,
];
}, self::$requiredConfigfiles);
$response = [
'configfiles' => $configfiles_status,
'description' => ' Issue can be resolved by simply <a href="https://www.uvdesk.com/en/blog/open-source-helpdesk-installation-on-ubuntu-uvdesk/" target="_blank"> enabling read/write permissions for your files under config/packages folder of your project.</a>',
];
break;
default:
$code = 404;
break;
}
return new Response(json_encode($response ?? []), $code ?? 200, self::DEFAULT_JSON_HEADERS);
}
public function verifyDatabaseCredentials(Request $request)
{
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
try {
$entityManager = EntityManager::create([
'driver' => 'pdo_mysql',
"host" => $request->request->get('serverName'),
"port" => $request->request->get('serverPort'),
'user' => $request->request->get('username'),
'password' => $request->request->get('password'),
], Setup::createAnnotationMetadataConfiguration(['src/Entity'], false));
$databaseConnection = $entityManager->getConnection();
// Establish a connection if not active
if (false == $databaseConnection->isConnected()) {
$databaseConnection->connect();
}
// Check if database exists
$createDatabase = (bool) $request->request->get('createDatabase');
if (!in_array($request->request->get('database'), $databaseConnection->getSchemaManager()->listDatabases()) && false == $createDatabase) {
return new JsonResponse([
'status' => false,
'message' => "The requested database was not found."
]);
}
// Storing database configuration to session.
$_SESSION['DB_CONFIG'] = [
'host' => $request->request->get('serverName'),
"port" => $request->request->get('serverPort'),
'username' => $request->request->get('username'),
'password' => $request->request->get('password'),
'database' => $request->request->get('database'),
'createDatabase' => $createDatabase,
];
} catch (\Exception $e) {
return new JsonResponse([
'status' => false,
'message' => "Failed to establish a connection with database server."
]);
}
return new JsonResponse(['status' => true]);
}
public function prepareSuperUserDetailsXHR(Request $request)
{
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
// unset($_SESSION['USER_DETAILS']);
$_SESSION['USER_DETAILS'] = [
'name' => $request->request->get('name'),
'email' => $request->request->get('email'),
'password' => $request->request->get('password'),
];
return new Response(json_encode(['status' => true]), 200, self::DEFAULT_JSON_HEADERS);
}
public function updateConfigurationsXHR(Request $request, KernelInterface $kernel)
{
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
$database_host = $_SESSION['DB_CONFIG']['host'];
$database_port = $_SESSION['DB_CONFIG']['port'];
$database_user = $_SESSION['DB_CONFIG']['username'];
$database_pass = $_SESSION['DB_CONFIG']['password'];
$database_name = $_SESSION['DB_CONFIG']['database'];
$create_database = $_SESSION['DB_CONFIG']['createDatabase'];
try {
$entityManager = EntityManager::create([
'driver' => 'pdo_mysql',
"host" => $database_host,
"port" => $database_port,
'user' => $database_user,
'password' => $database_pass,
], Setup::createAnnotationMetadataConfiguration(['src/Entity'], false));
// Establish an active connection with database server
$databaseConnection = $entityManager->getConnection();
if (false == $databaseConnection->isConnected()) {
$databaseConnection->connect();
}
// Check if database exists
if (!in_array($database_name, $databaseConnection->getSchemaManager()->listDatabases())) {
if (false == $create_database) {
throw new \Exception('Database does not exist.');
}
// Create database
$databaseConnection->getSchemaManager()->createDatabase($databaseConnection->getDatabasePlatform()->quoteSingleIdentifier($database_name));
}
// Update .env
$application = new Application($kernel);
$application->setAutoExit(false);
$returnCode = $application->run(new ArrayInput([
'command' => 'uvdesk_wizard:env:update',
'name' => 'DATABASE_URL',
'value' => sprintf("mysql://%s:%s@%s/%s", $database_user, urlencode($database_pass), $database_host . ($database_port ? ':' . $database_port : ''), $database_name)
]), new NullOutput());
if (0 === $returnCode) {
return new JsonResponse(['success' => true]);
}
} catch (\Exception $e) {
// Dump Exception ...
dump($e->getMessage()); die;
}
return new JsonResponse(['success' => false], 500);
}
public function migrateDatabaseSchemaXHR(Request $request, KernelInterface $kernel)
{
$application = new Application($kernel);
$application->setAutoExit(false);
$resultCode = $application->run(new ArrayInput([
'command' => 'uvdesk_wizard:database:migrate'
]), new NullOutput());
return new Response(json_encode([]), 200, self::DEFAULT_JSON_HEADERS);
}
public function populateDatabaseEntitiesXHR(Request $request, KernelInterface $kernel)
{
$application = new Application($kernel);
$application->setAutoExit(false);
$resultCode = $application->run(new ArrayInput([
'command' => 'doctrine:fixtures:load',
'--append' => true,
]), new NullOutput());
return new Response(json_encode([]), 200, self::DEFAULT_JSON_HEADERS);
}
public function createDefaultSuperUserXHR(Request $request)
{
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
// $entityManager = $this->getDoctrine()->getEntityManager();
$entityManager = $this->getDoctrine()->getManager();
$role = $entityManager->getRepository('UVDeskCoreFrameworkBundle:SupportRole')->findOneByCode('ROLE_SUPER_ADMIN');
$userInstance = $entityManager->getRepository('UVDeskCoreFrameworkBundle:UserInstance')->findOneBy([
'isActive' => true,
'supportRole' => $role,
]);
if (empty($userInstance)) {
list($name, $email, $password) = array_values($_SESSION['USER_DETAILS']);
// Retrieve existing user or generate new empty user
$accountExistsFlag = false;
$user = $entityManager->getRepository('UVDeskCoreFrameworkBundle:User')->findOneByEmail($email) ?: (new CoreEntities\User())->setEmail($email);
if ($user->getId() != null) {
$userInstance = $user->getAgentInstance();
if (!empty($userInstance)) {
$accountExistsFlag = true;
if ($userInstance->getSupportRole()->getId() != $role->getId()) {
$userInstance->setSupportRole($role);
$entityManager->persist($userInstance);
$entityManager->flush();
}
}
} else {
$username = explode(' ', $name, 2);
$encodedPassword = $this->get('security.password_encoder')->encodePassword($user, $password);
$user
->setFirstName($username[0])
->setLastName(!empty($username[1]) ? $username[1] : '')
->setPassword($encodedPassword)
->setIsEnabled(true);
$entityManager->persist($user);
$entityManager->flush();
}
if (false == $accountExistsFlag) {
$userInstance = new CoreEntities\UserInstance();
$userInstance->setSource('website');
$userInstance->setIsActive(true);
$userInstance->setIsVerified(true);
$userInstance->setUser($user);
$userInstance->setSupportRole($role);
$entityManager->persist($userInstance);
$entityManager->flush();
}
}
return new Response(json_encode([]), 200, self::DEFAULT_JSON_HEADERS);
}
public function websiteConfigurationXHR(Request $request)
{
switch ($request->getMethod()) {
case "GET":
$currentWebsitePrefixCollection = $this->get('uvdesk.service')->getCurrentWebsitePrefixes();
if ($currentWebsitePrefixCollection) {
$result = $currentWebsitePrefixCollection;
$result['status'] = true;
} else {
$result['status'] = false;
}
break;
case "POST":
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
$_SESSION['PREFIXES_DETAILS'] = [
'member' => $request->request->get('member-prefix'),
'customer' => $request->request->get('customer-prefix'),
];
$result = ['status' => true];
break;
default:
break;
}
return new Response(json_encode($result ?? []), 200, self::DEFAULT_JSON_HEADERS);
}
public function updateWebsiteConfigurationXHR(Request $request)
{
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
$collectionURL= $this->get('uvdesk.service')->updateWebsitePrefixes(
$_SESSION['PREFIXES_DETAILS']['member'],
$_SESSION['PREFIXES_DETAILS']['customer']
);
return new Response(json_encode($collectionURL), 200, self::DEFAULT_JSON_HEADERS);
}
}

src/Controller/ConfigureHelpdesk.php line 54