Symfony Profiler

<?php
namespace Webkul\UVDesk\SupportCenterBundle\Controller;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\Common\Collections\Criteria;
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\HttpFoundation\JsonResponse;
use Webkul\UVDesk\SupportCenterBundle\Entity\Article as ArticleEntity;
use Webkul\UVDesk\SupportCenterBundle\Entity\ArticleCategory;
use Webkul\UVDesk\SupportCenterBundle\Entity\ArticleRelatedArticle;
use Webkul\UVDesk\SupportCenterBundle\Entity\ArticleHistory;
use Webkul\UVDesk\CoreFrameworkBundle\Entity\Tag;
use Webkul\UVDesk\SupportCenterBundle\Entity\ArticleTags;
use Webkul\UVDesk\SupportCenterBundle\Entity\SolutionCategory;
use Webkul\UVDesk\SupportCenterBundle\Form;
class Article extends Controller
{
public function articleList(Request $request)
{
if (!$this->get('user.service')->isAccessAuthorized('ROLE_AGENT_MANAGE_KNOWLEDGEBASE')) {
return $this->redirect($this->generateUrl('helpdesk_member_dashboard'));
}
$solutions = $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Solutions')
->getAllSolutions(null, $this->container, 'a.id, a.name');
if ($solutions) {
foreach($solutions as $key => $solution) {
$solutions[$key]['categories'] = $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Solutions')
->getCategoriesWithCountBySolution($solution['id']);
}
}
return $this->render('@UVDeskSupportCenter/Staff/Articles/articleList.html.twig', [
'solutions' => $solutions
]);
}
public function articleListByCategory(Request $request)
{
$category = $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:SolutionCategory')
->findCategoryById(['id' => $request->attributes->get('category')]);
if ($category) {
return $this->render('@UVDeskSupportCenter/Staff/Articles/articleListByCategory.html.twig',[
'category' => $category,
'articleCount' => $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:SolutionCategory')
->getArticlesCountByCategory($request->attributes->get('category')),
'categorySolutions' => $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:SolutionCategory')
->getSolutionsByCategory($request->attributes->get('category')),
'solutions' => $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Solutions')
->getAllSolutions(null, $this->container, 'a.id, a.name')
]);
} else {
$this->noResultFound();
}
}
public function ArticleListBySolution(Request $request)
{
$solution = $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Solutions')
->findSolutionById(['id' => $request->attributes->get('solution')]);
if ($solution) {
return $this->render('@UVDeskSupportCenter/Staff/Articles/articleListBySolution.html.twig', [
'solution' => $solution,
'solutionArticleCount' => $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Solutions')
->getArticlesCountBySolution($request->attributes->get('solution')),
'solutionCategoryCount' => $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Solutions')
->getCategoriesCountBySolution($request->attributes->get('solution')),
]);
} else {
$this->noResultFound();
}
}
public function articleListXhr(Request $request)
{
$json = array();
$repository = $this->getDoctrine()->getRepository('UVDeskSupportCenterBundle:Article');
if($request->attributes->get('category'))
$request->query->set('categoryId', $request->attributes->get('category'));
if($request->attributes->get('solution'))
$request->query->set('solutionId', $request->attributes->get('solution'));
// Pasar flag para listar solo subartículos si la ruta lo define
if ($request->attributes->get('isSubarticle')) {
$request->query->set('isSubarticle', 1);
}
$json = $repository->getAllArticles($request->query, $this->container);
$response = new Response(json_encode($json));
$response->headers->set('Content-Type', 'application/json');
return $response;
}
public function articleHistoryXhr(Request $request)
{
$json = array();
$repository = $this->getDoctrine()->getRepository('UVDeskSupportCenterBundle:Article');
$params = ['articleId' => $request->attributes->get('id')];
$json = $repository->getAllHistoryByArticle($params);
if ($json) {
foreach($json as $key => $js) {
$json[$key]['dateAdded'] = [
'format' => $this->container->get('user.service')->convertToTimezone($js['dateAdded']),
'timestamp' => $this->container->get('user.service')->convertToDatetimeTimezoneTimestamp($js['dateAdded']),
];
}
}
$response = new Response(json_encode($json));
$response->headers->set('Content-Type', 'application/json');
return $response;
}
public function articleRelatedXhr(Request $request)
{
$json = array();
$repository = $this->getDoctrine()->getRepository('UVDeskSupportCenterBundle:Article');
$params = ['articleId' => $request->attributes->get('id')];
$json = $repository->getAllRelatedyByArticle($params);
$response = new Response(json_encode($json));
$response->headers->set('Content-Type', 'application/json');
return $response;
}
protected function getArticle($filterArray = array())
{
if ($filterArray) {
return $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Article')
->findOneBy($filterArray);
}
return false;
}
public function article(Request $request)
{
if ($request->attributes->get('id')) {
$article = $this->getArticle(['id' => $request->attributes->get('id')]);
if(!$article)
$this->noResultFound();
} else {
$article = new ArticleEntity;
}
$articleCategory = $articleTags = [];
if ($article->getId()) {
$articleCategory = $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Article')
->getCategoryByArticle($article->getId());
$articleTags = $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Article')
->getTagsByArticle($article->getId());
}
$categories = $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:SolutionCategory')
->getAllCategories(null, $this->container, 'a.id, a.name');
$conn = $this->getDoctrine()->getConnection();
$rows = $conn->fetchAll('SELECT id FROM uv_article WHERE parent_article_id IS NULL ORDER BY name ASC');
$ids = array_column($rows, 'id');
$parentArticles = [];
if (!empty($ids)) {
$parentArticles = $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Article')
->findBy(['id' => $ids], ['name' => 'ASC']);
}
if ($request->attributes->get('id')) {
return $this->render('@UVDeskSupportCenter/Staff/Articles/articleForm.html.twig', [
'article' => $article,
'articleCategory' => $articleCategory,
'articleTags' => $articleTags,
'categories' => $categories,
'parentArticles' => $parentArticles,
]);
}
return $this->render('@UVDeskSupportCenter/Staff/Articles/articleAddForm.html.twig', [
'article' => $article,
'parentArticles' => $parentArticles,
]);
}
public function articleXhr(Request $request)
{
$json = array();
if ($request->getMethod() == "POST") {
$data = $request->request->get("data");
$entityManager = $this->getDoctrine()->getManager();
if (isset($data['actionType'])) {
switch ($data['actionType']) {
case 'articleUpdate':
case 'articleSave':
if ('articleSave' == $data['actionType'] && !empty($resources['articles']['showAlert']) ) {
$json['alertClass'] = 'danger';
return new JsonResponse($json);
}
if ($data['ids'][0]) {
$article = $this->getArticle(['id' => $data['ids'][0]]);
} else {
$article = new ArticleEntity;
}
$json['errors'] = [];
if ($article) {
if (strlen($data['name']) > 200) {
$json['errors']['name'] = 'Name length must not be greater than 200 !!';
}
if (!$json['errors']) {
unset($json['errors']);
$article->setName($data['name']);
$article->setSlug($data['slug']);
$article->setMetaTitle($data['metaTitle']);
$article->setKeywords($data['keywords']);
$article->setMetaDescription($data['metaDescription']);
// Parent article (subarticle support)
$parentId = isset($data['parentArticleId']) && $data['parentArticleId'] !== '' ? (int) $data['parentArticleId'] : null;
$article->setParentArticleId($parentId);
$updateRevisionHistory = false;
if ($article->getContent() == null || trim($article->getContent()) != trim($data['content'])) {
$updateRevisionHistory = true;
$article->setContent($data['content']);
}
// Persistir primero el artículo con Doctrine
$entityManager->persist($article);
$entityManager->flush();
// Actualizar parent_article_id mediante SQL nativo
$parentId = isset($data['parentArticleId']) && $data['parentArticleId'] !== '' ? (int) $data['parentArticleId'] : null;
$conn = $entityManager->getConnection();
if ($parentId !== null) {
$conn->executeUpdate(
'UPDATE uv_article SET parent_article_id = :pid WHERE id = :id',
['pid' => $parentId, 'id' => $article->getId()]
);
} else {
$conn->executeUpdate(
'UPDATE uv_article SET parent_article_id = NULL WHERE id = :id',
['id' => $article->getId()]
);
}
$entityManager->persist($article);
$entityManager->flush();
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success! Article updated successfully');
if (!$data['ids'][0]) {
$json['redirect'] = $this->generateUrl('helpdesk_member_knowledgebase_update_article', array('id' => $article->getId()));
}
} else {
$json['alertClass'] = 'danger';
$json['alertMessage'] ='Warning! Correct all field values first!';
}
} else {
$json['alertClass'] = 'danger';
$json['alertMessage'] = $this->get('translator')->trans('Warning ! This is not a valid request');
}
break;
case 'status':
$entityManager->getRepository('UVDeskSupportCenterBundle:Article')->bulkArticleStatusUpdate($data['ids'], $data['targetId']);
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Article updated successfully.');
break;
case 'tagUpdate':
if ($data['action'] == 'remove') {
$entityManager->getRepository('UVDeskSupportCenterBundle:Article')->removeTagByArticle($data['ids'][0], [$data['entityId']]);
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Tag removed successfully.');
break;
} elseif ($data['action'] == 'add') {
$articleTagMapping = new ArticleTags();
$articleTagMapping->setArticleId($data['ids'][0]);
$articleTagMapping->setTagId($data['entityId']);
$entityManager->persist($articleTagMapping);
$entityManager->flush();
} elseif ($data['action'] == 'create') {
$tag = $entityManager->getRepository('UVDeskCoreFrameworkBundle:Tag')->findOneBy(['name' => $data['name']]);
if (!$tag) {
$tag = new Tag();
$tag->setName($data['name']);
$entityManager->persist($tag);
$entityManager->flush();
}
$articleTagMapping = new ArticleTags();
$articleTagMapping->setArticleId($data['ids'][0]);
$articleTagMapping->setTagId($tag->getId());
$entityManager->persist($tag);
$entityManager->persist($articleTagMapping);
$entityManager->flush();
$json['tagId'] = $tag->getId();
$json['tagName'] = $tag->getName();
}
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Tags Saved successfully.');
break;
case 'contentUpdate':
$article = $this->getArticle(['id' => $data['ids'][0]]);
if ($article) {
if (trim($article->getContent()) != trim($data['content']))
$this->updateContent($article, $data['content']);
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Revision restored successfully.');
} else {
$json['alertClass'] = 'danger';
$json['alertMessage'] = $this->get('translator')->trans('Warning ! This is not a valid request');
}
break;
case 'categoryUpdate':
if ($data['action'] == 'remove') {
$this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Article')
->removeCategoryByArticle($data['ids'][0], [$data['entityId']]);
} else if ($data['action'] == 'add') {
$articleCategoryMapping = new ArticleCategory();
$articleCategoryMapping->setArticleId($data['ids'][0]);
$articleCategoryMapping->setCategoryId($data['entityId']);
$entityManager->persist($articleCategoryMapping);
$entityManager->flush();
}
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Categories updated successfully.');
break;
case 'relatedUpdate':
if ($data['action'] == 'remove') {
$entityManager->getRepository('UVDeskSupportCenterBundle:Article')->removeRelatedByArticle($data['ids'][0], [$data['entityId']]);
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Article Related removed successfully.');
} else if($data['action'] == 'add') {
$relatedArticles = $entityManager->getRepository('UVDeskSupportCenterBundle:ArticleRelatedArticle')->findBy([
'articleId' => $data['ids'][0],
'relatedArticleId' => $data['entityId'],
]);
if (count($relatedArticles)) {
$json['alertClass'] = 'success';
$json['alertMessage'] ='Success ! Article Related is already added.';
} elseif ($data['ids'][0] == $data['entityId']) {
$json['alertClass'] = 'danger';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Cannot add self as relative article.');
} else {
$articleRelatedMapping = new ArticleRelatedArticle();
$articleRelatedMapping->setArticleId($data['ids'][0]);
$articleRelatedMapping->setRelatedArticleId($data['entityId']);
$entityManager->persist($articleRelatedMapping);
$entityManager->flush();
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Article Related updated successfully.');
}
}
break;
case 'delete':
if ($data['ids']) {
foreach ($data['ids'] as $id) {
$article = $entityManager->getRepository('UVDeskSupportCenterBundle:Article')->find($id);
if ($article) {
$entityManager->remove($article);
$entityManager->flush();
}
}
$this->removeArticle($article);
}
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Articles removed successfully.');
break;
default:
$json['alertClass'] = 'danger';
$json['alertMessage'] = $this->get('translator')->trans('Warning ! This is not a valid request');
}
}
} elseif ($request->getMethod() == "PATCH") {
$entityManager = $this->getDoctrine()->getManager();
$data = json_decode($request->getContent(), true);
if (isset($data['editType']))
switch($data['editType']) {
case 'status':
$entityManager->getRepository('UVDeskSupportCenterBundle:Article')->bulkArticleStatusUpdate([$data['id']], $data['value']);
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Article status updated successfully.');
break;
case "stared":
$article = $entityManager->getRepository('UVDeskSupportCenterBundle:Article')->findOneBy(['id' => $data['id']]);
if ($article) {
$article->setStared( (isset($data['value']) && $data['value'] == 1) ? 1 : 0 );
$entityManager->persist($article);
$entityManager->flush();
}
$json['alertClass'] = 'success';
$json['alertMessage'] ='Success ! Article star updated successfully.';
break;
case "update":
$articleBase = $this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:SolutionCategory')
->find($data['id']);
if ($articleBase) {
if (isset($data['name']) && strlen($data['name']) > 200) {
$json['alertClass'] = 'danger';
$json['alertMessage'] = 'Name length must not be greater than 200 !!';
} else {
$articleBase->setName($this->get('uvdesk.service')->htmlfilter($data['name']));
if(trim($articleBase->getContent()) != trim($data['content']))
$this->updateContent($request, $articleBase, $data['content']);
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success! Article updated successfully');
}
}
case 'status':
$entityManager->getRepository('WebkulSupportCenterBundle:Article')->bulkArticleStatusUpdate([$data['id']], $data['value']);
$json['alertClass'] = 'success';
$json['alertMessage'] = $this->get('translator')->trans('Success ! Article status updated successfully.');
break;
default:
$json['alertClass'] = 'danger';
$json['alertMessage'] = $this->get('translator')->trans('Warning ! This is not a valid request');
}
}
$response = new Response(json_encode($json));
$response->headers->set('Content-Type', 'application/json');
return $response;
}
private function updateContent($articleBase, $content, $updateArticle = true)
{
$entityManager = $this->getDoctrine()->getManager();
$articleHistory = new ArticleHistory;
$articleHistory->setUserId($this->getUser()->getId());
$articleHistory->setArticleId($articleBase->getId());
$articleHistory->setContent($articleBase->getContent());
if ($updateArticle) {
$articleBase->setContent($content);
$entityManager->persist($articleBase);
}
$entityManager->persist($articleHistory);
$entityManager->flush();
}
private function removeArticle($article)
{
$this->getDoctrine()
->getRepository('UVDeskSupportCenterBundle:Article')
->removeEntryByArticle($article->getId());
}
}

vendor/uvdesk/support-center-bundle/Controller/Article.php line 71