Symfony Profiler

<?php
namespace OceanExpertBundle\Controller;
use CommerceGuys\Addressing\Formatter\DefaultFormatter;
use CommerceGuys\Addressing\Model\Address;
use CommerceGuys\Addressing\Repository\AddressFormatRepository;
use CommerceGuys\Addressing\Repository\CountryRepository;
use CommerceGuys\Addressing\Repository\SubdivisionRepository;
use DateTime;
use Doctrine\ORM\AbstractQuery;
use Doctrine\ORM\Query;
use Exception;
use OceanExpertBundle\Controller\Api\ApiReportsController;
use OceanExpertBundle\Entity\Institutions;
use Psr\Container\ContainerExceptionInterface;
use Psr\Container\NotFoundExceptionInterface;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\HttpFoundation\RedirectResponse;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
class InstitutionController extends AbstractController
{
/**
* get the list of all institutes for a given countryCode/Id
*
* @param Request $request
*
* @return JsonResponse
*/
public function getInstitutionByCountryAction(Request $request): JsonResponse
{
$instituteList = array();
if ($request->query->get('countryCode') == NULL) {
$instituteList = array(
'institution' => 'Select Country First.'
);
} else {
$countryCode = $request->query->get('countryCode');
$repo = $this->getDoctrine()
->getRepository('OceanExpertBundle:Institutions');
$query = $repo->createQueryBuilder('a')
->select('distinct a.instName, a.idInst, a.instAddress, a.city, a.state, a.postcode, a.idInst, a.activated')
->where('a.countryCode = :code')
->andWhere('a.activated in (0,1)')
->orderBy('a.instName', 'ASC')
->setParameter('code', $countryCode);
if ($request->query->get('search') !== '') {
$query = $query->andWhere('a.instName like :search')
->setParameter('search', '%' . $request->query->get('search') . '%');
}
$query = $query->getQuery();
$instituteList = $query->getResult();
}
return new JsonResponse($instituteList);
}
/**
* get the information about an institute with a given id
*
* @param Request $request
*
* @return JsonResponse
*/
public function getInstitutionAddressAction(Request $request): Response
{
$instituteDetails = array();
if ($request->query->get('instName') != NULL) {
$idInst = $request->query->get('instName');
$repo = $this->getDoctrine()
->getRepository('OceanExpertBundle:Institutions');
$query = $repo->createQueryBuilder('a')
->select('
a.instName,
a.instAddress,
a.addr2,
a.postcode,
a.city,
a.state,
a.countryCode,
a.instTel
')
->where('a.idInst = :idInst')
// ->setParameter('title',$title)
->setParameter('idInst', $idInst)
->getQuery();
$instituteDetails = $query->getResult();
return new JsonResponse($instituteDetails);
} else {
return new JsonResponse(
array(
'status' => 0,
'message' => 'need an id of the institute'
)
);
}
}
/**
* add a new institute
*
* @deprecated
*
* @param Request $request
*
* @return Response
*/
public function addInstitutionAction(Request $request): Response
{
return $this->addInstituteAction($request);
}
/**
* add a new institute
*
* @param Request $request
*
* @return Response
*/
public function addInstituteAction(Request $request): Response
{
$data = $request->request->all();
$securityContext = $this->get('security.authorization_checker');
if ($securityContext->isGranted('IS_AUTHENTICATED_FULLY')) {
$em = $this->getDoctrine()->getManager();
$userId = $this->get('security.token_storage')->getToken()->getUser()->getId();
//let's check if the logged-in user has a 'real' profile
//the mandatory profile fields are all filled and the expert is active
// Arno 21/06/23 : we will not check this for the time being see also #521
//if people cannot create their institute while registering they will not make / add it later
/*
if (!SecurityController::checkUserProfile($em, $userId)) {
return $this->redirect(
$this->generateUrl(
'user_profile_edit'
)
);
}
*/
//this is here to prevent breaking inst creation by something else that 'edit/create profile'
if (null !== $request->request->get('instCountryCode')) {
//this is correct and used by 'edit/create profile'
$countryCode = $request->request->get('instCountryCode');
} else {
//this may be incorrect as we need the country code of the inst
//and on some page this is mixed with country code of the expert
$countryCode = $request->request->get('countryCode');
}
if (trim($request->request->get("iedmo")) == ''
|| !is_numeric($request->request->get("iedmo"))
) {
$edmo_code = 0;
} else {
$edmo_code = $request->request->get("iedmo");
}
$instituteDetails = array();
$repo = $this->getDoctrine()
->getRepository('OceanExpertBundle:Institutions');
$query = $repo->createQueryBuilder('a')
->select('a.idInst, a.instName, a.instAddress, a.city, a.state, a.postcode, a.instTel')
->where('a.instName like :name')
->andWhere('a.countryCode = :countryCode')
->setParameter('name', $request->request->get('instName'))
->setParameter('countryCode', $countryCode)
->getQuery();
$instituteDetails = $query->getResult();
if (count($instituteDetails) == 0) {
try {
$institute = new Institutions();
$institute->setCountryCode($countryCode);
$institute->setInstName($request->request->get('instName'));
$institute->setInstNameEng($request->request->get('instNameEng'));
$institute->setInstTypeID($request->request->get('instType'));
$institute->setParentId($request->request->get('parentinstitute'));
if (null == $institute->getParentId()) {
$institute->setParentId(0);
}
$institute->setInstAddress($request->request->get('iaddress'));
$institute->setAcronym($request->request->get('iacronym'));
$institute->setAddr2($request->request->get('iaddress2'));
$institute->setPostcode($request->request->get('ipostcode'));
$institute->setCity($request->request->get('icity'));
$institute->setState($request->request->get('istate'));
$institute->setInstTel($request->request->get('icontact'));
$institute->setInstFax($request->request->get('ifax'));
$institute->setInstEmail($request->request->get('iemail'));
$institute->setInstURL($request->request->get('iwebsite'));
$institute->setEdmoCode($edmo_code);
$institute->setActivities($request->request->get('iactivity'));
if (null !== $request->request->get('isearegion')
&& is_array($request->request->get('isearegion'))
&& count($request->request->get('isearegion')) > 1
) {
$iseaRegion = implode(',', $request->request->get('isearegion'));
} else {
$iseaRegion = '';
}
$institute->setInstRegion($iseaRegion);
$institute->setPopularity(0);
if ($this->get('security.authorization_checker')->isGranted('ROLE_LME')) {
$institute->setActivated(1);
} else {
$institute->setActivated(0);
}
$institute->setFDateEntered(new DateTime('now'));
$institute->setLDateUpdated(new DateTime('now'));
$institute->setCreatedBy($userId);
$em->persist($institute); //marks object to be saved in the next transaction.
$em->flush(); //performs all saves and transactions.
$logoFilename = 'instituteLogo.jpg';
$logoDirectory = 'uploads/institutes/' . $institute->getIdInst() . '/';
if (null != $request->files->get('instLogo')) {
$file = $request->files->get('instLogo');
$file->move($logoDirectory, $logoFilename);
$institute->setInstLogo($logoFilename);
} else {
if (isset($data['textLogo']) && $data['textLogo'] == '') {
$institute->setInstLogo('');
$filename = $logoDirectory . $logoFilename;
if (file_exists($filename)) {
unlink($filename);
}
}
}
$em->persist($institute);
$em->flush();
return new JsonResponse(
array(
'status' => 1,
'id' => $institute->getIdInst(),
'message' => '<br /><br /><h3 class="text-success">institute created</h3>
Your new institute has been created successfully<br />
and should be already selected in the list of institutes.<br />
If this is not the case, please select your newly created institute in the list.
<br /><br />'
)
);
} catch (Exception $e) {
return new JsonResponse(
array(
'status' => 0,
'message' => 'Error in adding Institute. Please try again later.'
)
);
}
} else {
foreach ($instituteDetails as $instituteDetail) {
$existingInstitutes[] = '<a
href="/institute/' . $instituteDetail['idInst'] . '"
target="_new">' .
$instituteDetail['instName'] .
'</a>';
}
$existingInstitutes = implode(',', $existingInstitutes);
return new JsonResponse(
array(
'status' => 2,
'message' => "Institute name/acronym already exists. ($existingInstitutes)"
)
);
}
} else {
return new JsonResponse(
array(
'status' => 2,
'message' => 'you do not have the correct rights to do this'
)
);
}
}
/**
* get all existing institutes
*
* @return Response
*/
public function getAllInstitutions(): Response
{
$institutesQuery = $this->getAllInstitutionsQuery();
$institutesTmp = $institutesQuery->execute();
$institutes = array();
foreach($institutesTmp as $institute) {
$institutes[$institute['idInst']] = $institute;
}
return new Response(json_encode($institutes));
}
/**
* get the query to get all existing institutes
*
* @param string $query
*
*/
private function getAllInstitutionsQuery(
$query = ''
) {
//get the institutes
$repo = $this->getDoctrine()
->getRepository('OceanExpertBundle:Institutions');
$institutes = $repo->createQueryBuilder('i');
$institutes->select('
i.idInst,
i.parentId,
i.instTypeId,
i.instName,
i.instNameEng,
i.countryCode,
c.country,
it.insttypeName'
);
$institutes->leftJoin(
'OceanExpertBundle:Countries',
'c',
'WITH',
'i.countryCode = c.idCountry');
$institutes->leftJoin(
'OceanExpertBundle:Insttypes',
'it',
'WITH',
'i.instTypeId = it.idInsttype');
//non-admin users only get the active ones
if (!$this->get('security.authorization_checker')->isGranted('ROLE_SUPERADMIN')
&& !$this->get('security.authorization_checker')->isGranted('ROLE_ADMIN')
) {
$institutes->where('i.activated = 1');
}
if (trim($query) != '') {
$institutes->andwhere('i.instName LIKE :query OR i.instNameEng LIKE :query');
$institutes->setParameter(
'query',
'%' . trim($query) . '%'
);
}
//store all the found institutes to be able to find the name of the parents
$institutesQuery = $institutes->getQuery();
return $institutesQuery;
}
/**
* show all existing institutes
*
* @param Request $request
*
* @return Response|void
*/
function viewInstitutesAction( Request $request ): Response
{
$limits = array(
10 => 10,
25 => 25,
50 => 50,
100 => 100,
500 => 500
);
$limit = $request->query->get('limit', 10);
$query = $request->query->get('search', '');
$orderby = $request->query->get('orderby', 'order');
$dir = $request->query->get('dir', 'asc');
//store all the found institutes to be able to find the name of the parents
$institutesQuery = $this->getAllInstitutionsQuery($query);
$institutesTmp = $institutesQuery->execute();
foreach($institutesTmp as $institute) {
$parentInstitutes[$institute['idInst']] = $institute['instName'];
}
$paginator = $this->get('knp_paginator');
$data = $paginator->paginate(
$institutesQuery,
$request->query->getInt('page', 1),
$limit,
array(
'pageParameterName' => 'page',
'sortDirectionParameterName' => 'dir',
'defaultSortDirection' => 'desc'
)
);
$data->setCustomParameters([
'limits' => $limits,
'title' => 'Institutes'
]);
return $this->render(
'Institute/viewInstitutes.html.twig',
array(
'institutesData' => $data,
'parentInstitutes' => $parentInstitutes
)
);
}
/**
* this is here for backwards compatibility
*
* @deprecated
*
* @param int $instId
* @param Request $request
*
* @return RedirectResponse|Response
* @throws ContainerExceptionInterface
* @throws NotFoundExceptionInterface
*/
public function viewInstitutionAction(int $instId, Request $request)
{
return $this->viewInstituteAction($instId, $request);
}
/**
* view the details of an institute
* This is used for both viewing and editing an institute.
*
* @param int $instId
* @param Request $request
*
* @return RedirectResponse|Response
* @throws ContainerExceptionInterface
* @throws NotFoundExceptionInterface
*/
public function viewInstituteAction(int $instId, Request $request)
{
if (!is_numeric($instId)) {
return $this->render(
'Exception/error.html.twig',
array(
'message' => 'The institute id should be a numberic value, "' . $instId . '" given instead.'
)
);
}
/*
* container to hold to OIH/ODIS JSON-LD info
* see also https://book.oceaninfohub.org/thematics/expinst/README.html
* in the end we will need something like
* {
"@context": {
"@vocab": "https://schema.org/"
},
"@id": "https://example.org/id/org/x",
"@type": "Organization",
"address": {
"@type": "PostalAddress",
"addressLocality": "Paris, France",
"postalCode": "F-75002",
"streetAddress": "38 avenue de l'Opera"
},
"email": "secretariat(at)example.org",
"name": "Organization X",
"description": "Description of org ...",
"telephone": "( 33 1) 42 68 53 00",
"member": [
{
"@type": "Organization",
"name": "Organization A",
"description": "Org A is a potential parent organization of Org X"
}
],
"identifier": {
"@id": "https://grid.ac/institutes/grid.475727.4",
"@type": "PropertyValue",
"description": "UN Department of Economic and Social Affairs Sustainable Development",
"propertyID": "https://registry.identifiers.org/registry/grid",
"url": "https://grid.ac/institutes/grid.475727.4"
}
}
*/
$OIHData = array(
'@context' => array(
'@vocab' => 'https://schema.org/'
),
'@id' => "https://oceanexpert.org/institute/$instId",
'@type' => 'Organization'
);
if ($instId !== 0 ) {
$qb = $this->getDoctrine()->getManager()->createQueryBuilder();
$qb->add(
'select',
'ins.idInst,
ins.instTypeId,
ins.instName,
ins.instNameEng,
ins.instAddress,
ins.addr2,
ins.city,
ins.state,
ins.postcode,
ins.countryCode,
ins.acronym,
ins.instLogo,
ins.instTel,
ins.instFax,
ins.instEmail,
ins.instUrl,
ins.edmoCode,
ins.instRegion,
ins.activities,
ins.popularity,
ins.activated,
ins.fDateEntered,
ins.lDateUpdated,
ins.createdBy,
ins.lastEditBy,
it.insttypeName,
c.country,
c.countryCode as instCountryCode,
ins.parentId as parentIdInst,
p.instName as parentInstName,
p.instNameEng as parentInstNameEng,
p.acronym as parentAcronym,
p.instLogo as parentInstLogo')
->add(
'from',
'OceanExpertBundle:Institutions ins')
->leftJoin(
'OceanExpertBundle:Insttypes',
'it',
'WITH',
'it.idInsttype = ins.instTypeId')
->leftJoin(
'OceanExpertBundle:Countries',
'c',
'WITH',
'c.idCountry = ins.countryCode')
->leftJoin(
'OceanExpertBundle:Institutions',
'p',
'WITH',
'p.idInst = ins.parentId AND p.activated = 1')
->where('ins.idInst = :instId')
->setParameter(
'instId',
$instId
);
//get some info about the user asking this info
$userId = '-1';
$securityContext = $this->get('security.authorization_checker');
if ($securityContext->isGranted('IS_AUTHENTICATED_FULLY')) {
$userId = $this->get('security.token_storage')->getToken()->getUser()->getId();
}
if (!$securityContext->isGranted('ROLE_GLOBAL_EDITOR')) {
$qb->andWhere('ins.activated = 1');
}
$institute = $qb->getQuery()->getResult();
}
//get the list of all known institute types
$instituteTypes = [];
$instTypes = $this->getDoctrine()
->getRepository('OceanExpertBundle:Insttypes')
->findAll();
foreach ($instTypes as $instType) {
$instituteTypes[] = array(
'id' => $instType->getIdInsttype(),
'name' => $instType->getInsttypeName()
);
}
//get the list of all countries
$countries = $this->getDoctrine()
->getRepository('OceanExpertBundle:Countries')
->findBy(
[],
['country' => 'ASC']
);
//get the list of all available sea regions
$availableSeaRegions = $this->getDoctrine()
->getRepository('OceanExpertBundle:Searegions')
->createQueryBuilder('e')
->select('e.idSearegion as id, e.name')
->orderBy('e.name')
->getQuery()
->getResult(AbstractQuery::HYDRATE_ARRAY);
if ((!isset($institute)
|| !$institute)
&& $instId !== 0
) {
return $this->render(
'Exception/error.html.twig',
array(
'message' => 'the institute with id "' . $instId . '" does not exist or has not been approved by an OceanExpert editor (yet)'
)
);
} elseif ($instId == 0) {
//this is a new institute
$institute = array(
'idInst' => 0,
'instName' => '',
'instNameEng' => '',
'instAddress' => '',
'addr2' => '',
'city' => '',
'state' => '',
'postcode' => '',
'countryCode' => '',
'acronym' => '',
'instLogo' => '',
'instTel' => '',
'instFax' => '',
'instEmail' => '',
'instUrl' => '',
'edmoCode' => 0,
'instRegion' => '',
'activities' => '',
'country' => '',
'instTypeId' => '',
'parentIdInst' => '',
'parentInstName' => '',
);
$securityContext = $this->get('security.authorization_checker');
if (($request->request->get('instName') === ''
|| null === $request->request->get('instName'))
&& $securityContext->isGranted('IS_AUTHENTICATED_FULLY')
) {
return $this->render(
'Institute/editInstitute.html.twig',
array(
'institute' => $institute,
'instituteTypes' => $instituteTypes,
'countries' => $countries,
'countryInstitutes' => array(),
'availableSeaRegions' => $availableSeaRegions
)
);
} elseif ($securityContext->isGranted('IS_AUTHENTICATED_FULLY')) {
//create a new institute
$institute = new Institutions();
$institute->setInstName($request->request->get('instName'));
$institute->setInstNameEng($request->request->get('instNameEng'));
$institute->setInstAddress($request->request->get('iaddress'));
$institute->setAddr2($request->request->get('iaddressline2'));
$institute->setCity($request->request->get('icity'));
$institute->setState($request->request->get('istate'));
$institute->setPostcode($request->request->get('ipostcode'));
$institute->setCountryCode($request->request->get('instCountryCode'));
$institute->setInstTel($request->request->get('icontact'));
$institute->setInstFax($request->request->get('ifax'));
$institute->setInstEmail($request->request->get('iemail'));
$institute->setInstUrl($request->request->get('iwebsite'));
$institute->setEdmoCode($request->request->get('iedmo'));
$institute->setInstRegion($request->request->get('isearegion'));
$institute->setInstTypeId($request->request->get('instType'));
$institute->setParentId($request->request->get('parentinstitute'));
$institute->setActivities($request->request->get('iactivity'));
if (null == $institute->getParentId()) {
$institute->setParentId(0);
}
$institute->setPopularity(0);
$institute->setActivated(0);
$institute->setFDateEntered(new DateTime('now'));
$institute->setLDateUpdated(new DateTime('now'));
$institute->setCreatedBy($this->get('security.token_storage')->getToken()->getUser()->getId());
$institute->setLastEditBy($this->get('security.token_storage')->getToken()->getUser()->getId());
$institute->setInstLogo($request->request->get('instLogo'));
$institute->setInstTypeId($request->request->get('instType'));
$em = $this->getDoctrine()->getManager();
$em->persist($institute);
$em->flush();
$url = $this->generateUrl(
'view_institute',
array(
'instId' => $institute->getIdInst()
)
);
return new RedirectResponse($url);
} else {
return $this->render(
'Exception/error.html.twig',
array(
'message' => 'You need to be logged in to create a new institute.'
)
);
}
} else {
$institute = $institute[0];
$OIHData['name'] = $institute['instName'];
if (isset($institute['instUrl'])
&& $institute['instUrl'] != ''
) {
$OIHData['url'] = $institute['instUrl'];
} else {
$OIHData['url'] = "https://oceanexpert.org/institute/$instId";
}
if (isset($institute['instTel'])
&& $institute['instTel'] != ''
) {
$OIHData['telephone'] = $institute['instTel'];
}
if (isset($institute['parentIdInst'])
&& $institute['parentIdInst'] !== ''
&& $institute['parentIdInst'] !== 0
) {
$OIHData['memberOf'] = array(
'@type' => 'Organization',
'@id' => 'https://oceanexpert.org/institute/' . $institute['parentIdInst'],
'url' => 'https://oceanexpert.org/institute/' . $institute['parentIdInst'],
'name' => $institute['parentInstName']
);
}
}
//get the members of the institute
$qb = $this->getDoctrine()->getManager()->createQueryBuilder();
$qb->add(
'select',
'i.idInd,
i.fname,
i.mname,
i.sname,
i.jobtitle,
i.deceased,
i.retired,
i.qualityChecked')
->add(
'from',
'OceanExpertBundle:Indiv i')
->leftJoin(
'OceanExpertBundle:IndivInstitution',
'iins',
'WITH',
'iins.idInd = i.idInd')
->leftJoin(
'OceanExpertBundle:Institutions',
'ins',
'WITH',
'ins.idInst = iins.idInst')
->where('ins.idInst = :instId')
->andWhere('i.status = 1')
->orderBy(
'i.sname',
'ASC')
->setParameter(
'instId',
$instId
);
$instituteMembers = $qb->getQuery()->getResult();
if (is_array($instituteMembers)) {
foreach ($instituteMembers as $member) {
$OIHData['member'][] = array(
'member' => array(
'@type' => 'Person',
'@id' => 'https://oceanexpert.org/expert/' . $member['idInd'],
'url' => 'https://oceanexpert.org/expert/' . $member['idInd'],
'name' => $member['fname'] . ' ' . $member['mname'] . ' ' . $member['sname']
)
);
}
}
//what page with members are we showing
$paginator = $this->get('knp_paginator');
$memberLimit = $request->query->getInt('mlimit', 5);
$memberPage = $request->query->getInt('members', 1);
if (!in_array($memberLimit, array(5, 10, "All"))) {
$memberLimit = 5;
$memberPage = 1;
}
if ($memberLimit == "All") {
$memberLimit = 9999;
$memberPage = 1;
}
$members = $paginator->paginate(
$instituteMembers,
$memberPage,
$memberLimit,
array(
'pageParameterName' => 'members',
'sortDirectionParameterName' => 'dir'
)
);
//get the members of the child institutes
$qb = $this->getDoctrine()->getManager()->createQueryBuilder();
$qb->add(
'select',
'i.idInd,
i.fname,
i.mname,
i.sname,
i.jobtitle,
i.deceased,
i.retired,
i.qualityChecked,
ins.idInst,
ins.instName')
->add(
'from',
'OceanExpertBundle:Indiv i')
->leftJoin(
'OceanExpertBundle:IndivInstitution',
'iins',
'WITH',
'iins.idInd = i.idInd')
->leftJoin(
'OceanExpertBundle:Institutions',
'ins',
'WITH',
'ins.idInst = iins.idInst')
->where('ins.parentId = :instId')
->andWhere('i.status = 1')
->andWhere('ins.activated = 1')
->orderBy(
'i.sname',
'ASC')
->setParameter(
'instId',
$instId
);
$childInstituteMembers = $qb->getQuery()->getResult();
if (is_array($childInstituteMembers)) {
foreach ($childInstituteMembers as $member) {
$instUrl = 'https://oceanexpert.org/institute/' . $member['idInst'];
$instName = $member['instName'];
$OIHData['member'][] = array(
'member' => array(
'@type' => 'Person',
'@id' => 'https://oceanexpert.org/expert/' . $member['idInd'],
'url' => 'https://oceanexpert.org/expert/' . $member['idInd'],
'name' => $member['fname'] . ' ' . $member['mname'] . ' ' . $member['sname'],
'description' => "is member of '$instName' ($instUrl), a child of this organization"
)
);
}
}
//what page with child members are we showing
$childMemberLimit = $request->query->get('cmlimit');
if (!in_array($childMemberLimit, array(5, 10, "All"))) {
$childMemberLimit = 5;
}
if ($childMemberLimit == "All") {
$childMemberLimit = 9999;
}
$childMembers = $paginator->paginate(
$childInstituteMembers,
$request->query->getInt('childmembers', 1),
$childMemberLimit,
array(
'pageParameterName' => 'childmembers',
'sortDirectionParameterName' => 'dir'
)
);
//get the child institutes
$qb = $this->getDoctrine()->getManager()->createQueryBuilder();
$qb->add(
'select',
'ins.idInst,
ins.instTypeId,
ins.instName,
ins.instNameEng,
ins.instAddress,
ins.addr2,
ins.city,
ins.state,
ins.postcode,
ins.countryCode,
ins.acronym,
ins.instLogo,
ins.instTel,
ins.instFax,
ins.instEmail,
ins.instUrl,
ins.edmoCode,
ins.instRegion,
ins.activities,
ins.popularity,
ins.activated,
ins.fDateEntered,
ins.lDateUpdated,
ins.createdBy,
ins.lastEditBy,
it.insttypeName,
c.country,
c.countryCode as instCountryCode')
->add(
'from',
'OceanExpertBundle:Institutions ins')
->leftJoin(
'OceanExpertBundle:Insttypes',
'it',
'WITH',
'it.idInsttype = ins.instTypeId')
->leftJoin(
'OceanExpertBundle:Countries',
'c',
'WITH',
'c.idCountry = ins.countryCode')
->where('ins.parentId = :instId')
->andWhere('ins.activated = 1')
->orderBy(
'ins.instName',
'ASC')
->setParameter(
'instId',
$instId);
$childInstitutes = $qb->getQuery()->getResult();
if (is_array($childInstitutes)) {
foreach ($childInstitutes as $member) {
$OIHData['member'][] = array(
'member' => array(
'@type' => 'Organization',
'@id' => 'https://oceanexpert.org/institute/' . $member['idInst'],
'url' => 'https://oceanexpert.org/institute/' . $member['idInst'],
'name' => $member['instName']
)
);
}
}
//what page with child institutes are we showing
$childInstitutes = array();
$childInstituteLimit = $request->query->get('cilimit');
if (!in_array($childInstituteLimit, array(5, 10, "All"))) {
$childInstituteLimit = 5;
}
if ($childInstituteLimit == "All") {
$childInstituteLimit = 9999;
}
$childInstitutes = $paginator->paginate(
$childInstitutes,
$request->query->getInt('childinstitutes', 1),
$childInstituteLimit,
array(
'pageParameterName' => 'childinstitutes',
'sortDirectionParameterName' => 'dir'
)
);
//get the sea regions of the institute
$repository = $this->getDoctrine()
->getRepository('OceanExpertBundle:Searegions');
$institute['seaRegions'] = $repository->createQueryBuilder('r')
->select(
'r.idSearegion,
r.name')
->where('r.idSearegion IN (:seaRegions)')
->setParameter(
'seaRegions',
array_values(
explode(
',',
$institute['instRegion']
)
)
)
->getQuery()->getResult();
//what are we trying to do here - edit or view
$routeName = $request->get('_route');
if ($routeName == 'edit_institute'
|| $routeName == 'edit_institution'
) {
$securityContext = $this->container->get('security.authorization_checker');
if ($securityContext->isGranted('IS_AUTHENTICATED_FULLY')) {
$user = $this->container->get('security.token_storage')->getToken()->getUser();
//let's check if the logged-in user has a 'real' profile
//the mandatory profile fields are all filled and the expert is active
$em = $this->getDoctrine()->getManager();
$userId = $this->get('security.token_storage')->getToken()->getUser()->getId();
if (!SecurityController::checkUserProfile($em, $userId)) {
return $this->redirect(
$this->generateUrl(
'user_profile_edit'
)
);
}
if ($user->getId() == $institute['createdBy']
|| $this->get('security.authorization_checker')->isGranted('ROLE_GLOBAL_EDITOR')
) {
if (!empty($data = $request->request->all())) {
$em = $this->getDoctrine()->getManager();
if ($instId !== 0) {
$inst = $em
->getRepository('OceanExpertBundle:Institutions')
->findOneBy(
array(
'idInst' => $instId
)
);
} else {
$inst = new Institutions();
}
if ($inst) {
if (trim($data['iedmo']) == ''
|| !is_numeric($data['iedmo'])
) {
$edmo_code = 0;
} else {
$edmo_code = $data['iedmo'];
}
$inst->setInstTypeId($data['instType']);
$inst->setInstName($data['instName']);
$inst->setInstNameEng($data['instNameEng']);
$inst->setInstAddress($data['iaddress']);
$inst->setAddr2($data['iaddressline2']);
$inst->setCity($data['icity']);
$inst->setState($data['istate']);
$inst->setPostcode($data['ipostcode']);
$inst->setCountryCode($data['instCountryCode']);
$inst->setAcronym($data['iacronym']);
$inst->setInstTel($data['icontact']);
$inst->setInstFax($data['ifax']);
$inst->setInstEmail($data['iemail']);
$inst->setInstUrl($data['iwebsite']);
$inst->setEdmoCode($edmo_code);
$inst->setActivities($data['iactivity']);
if ($data['parentinstitute'] === '' ) {
$data['parentinstitute'] = 0;
}
$inst->setParentId($data['parentinstitute']);
if (isset($data['studyregion'])
&& count($data['studyregion']) > 0
) {
$inst->setInstRegion(implode(',', $data['studyregion']));
} else {
$inst->setInstRegion('');
}
$inst->setLDateUpdated(new DateTime("now"));
$inst->setLastEditBy($user->getId());
if (null != $request->files->get('instLogo')) {
$file = $request->files->get('instLogo');
$filename = 'instituteLogo.jpg';
$directory = 'uploads/institutes/' . $instId . '/';
$file->move($directory, $filename);
$inst->setInstLogo($filename);
} else {
if (isset($data['textLogo'])
&& $data['textLogo'] === ''
) {
$inst->setInstLogo('');
$filename = 'uploads/institutes/' . $inst->getIdInst() . '/instituteLogo.jpg';
if (file_exists($filename)) {
unlink($filename);
}
}
}
$em->persist($inst);
$em->flush();
return $this->redirect(
$this->generateUrl(
'edit_institute_success',
array(
'idInst' => $instId
)
)
);
} else {
return $this->render(
'Exception/error.html.twig',
array(
'message' => 'you are trying to edit an institute with id "' . $instId . '" that does not exist'
)
);
}
}
$countryInstitutes = $this->getDoctrine()
->getRepository('OceanExpertBundle:Institutions')
->findBy(
array(
'countryCode' => $institute['countryCode']
),
array(
'instName' => 'ASC'
)
);
return $this->render(
'Institute/editInstitute.html.twig',
array(
'institute' => $institute,
'instituteTypes' => $instituteTypes,
'countries' => $countries,
'countryInstitutes' => $countryInstitutes,
'availableSeaRegions' => $availableSeaRegions
)
);
} else {
return $this->render(
'Exception/error.html.twig',
array(
'message' => 'you do not have sufficient rights to edit the institute with id "' . $instId . '"'
)
);
}
} else {
return $this->render(
'Exception/error.html.twig',
array(
'message' => 'you need to log in to edit the institute with id "' . $instId . '"'
)
);
}
}
//show the institute info
$addressFormatRepository = new AddressFormatRepository();
$countryRepository = new CountryRepository();
$subdivisionRepository = new SubdivisionRepository();
$formatter = new DefaultFormatter($addressFormatRepository, $countryRepository, $subdivisionRepository);
$address = new Address();
$address = $address
->withCountryCode($institute['instCountryCode'])
->withAdministrativeArea($institute['state'])
->withLocality($institute['city'])
->withPostalCode($institute['postcode'])
->withAddressLine2($institute['addr2'])
->withAddressLine1($institute['instAddress']);
$institute['address'] = $formatter->format($address);
//make the address
$streetAddress = $institute['instAddress'];
if (trim($institute['addr2']) != '') {
$streetAddress .= ', ' . trim($institute['addr2']);
}
$address = $streetAddress . ', ' .
$institute['postcode'] . ' ' . $institute['city'] . ', ' .
$institute['country'];
$OIHData['location'] = array(
'@type' => 'Place',
'address' => trim($address)
);
$OIHData['address'] = array(
'@type' => 'PostalAddress',
'addressLocality' => $institute['city'] . ', ' . $institute['country'],
'postalCode' => $institute['postcode'],
'streetAddress' => $streetAddress
);
/*
$OIHData['location'] = array(
'@type' => 'Place',
'address' => array(
'@type' => 'PostalAddress',
'addressLocality' => $institute['city'] . ', ' . $institute['country'],
'postalCode' => $institute['postcode'],
'streetAddress' => $streetAddress
)
);
*/
if ($institute['createdBy']) {
$institute['createdId'] = $institute['createdBy'];
$institute['createdBy'] = $this->getUserById($institute['createdBy']);
}
if ($institute['lastEditBy']) {
$institute['lastEditId'] = $institute['lastEditBy'];
$institute['lastEditBy'] = $this->getUserById($institute['lastEditBy']);
}
$limits = array(
'memberlimit' => array(
'options' => array(
'5' => 5,
'10' => 10,
'9999' => 'All'
),
'selected' => $memberLimit
),
'childmemberlimit' => array(
'options' => array(
'5' => 5,
'10' => 10,
'9999' => 'All'
),
'selected' => $childMemberLimit
),
'childinstitutelimit' => array(
'options' => array(
'5' => 5,
'10' => 10,
'9999' => 'All'
),
'selected' => $childInstituteLimit
),
);
$OIHData = json_encode(
$OIHData,
JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_NUMERIC_CHECK
);
return $this->render(
'Institute/viewInstitute.html.twig',
array(
'OIHData' => $OIHData,
'institute' => $institute,
'members' => $members,
'limits' => $limits,
'childmembers' => $childMembers,
'childinstitutes' => $childInstitutes
)
);
}
public function getUserById($id = '')
{
$updatedBy = $this->getDoctrine()->getRepository('OceanExpertBundle:Indiv')->findOneByIdInd($id);
if ($updatedBy) {
$name = $updatedBy->getfname() . " " . $updatedBy->getsname();
} else {
$name = false;
}
return $name;
}
public function activateInstituteAction($instituteId)
{
$securityContext = $this->get('security.authorization_checker');
if ($securityContext->isGranted('ROLE_GLOBAL_EDITOR')) {
if ($instituteId) {
$institute = $this->getDoctrine()
->getRepository('OceanExpertBundle:Institutions')
->findOneByIdInst($instituteId);
if ($institute) {
$institute->setActivated(1);
$institute->setLDateUpdated(new DateTime("now"));
$institute->setLastEditBy(
$this->get('security.token_storage')
->getToken()
->getUser()
->getId()
);
$em = $this->getDoctrine()->getManager();
$em->persist($institute); //marks object to be saved in the next transaction.
$em->flush(); //performs all saves and transactions.
}
return new JsonResponse(
array(
'status' => true,
'msg' => 'Record updated successfully'
)
);
} else {
return new Response('Cannot update record.');
}
}
return new Response('Cannot update record.');
}
public function deactivateInstituteAction($instituteId)
{
$securityContext = $this->get('security.authorization_checker');
if ($securityContext->isGranted('ROLE_GLOBAL_EDITOR')) {
if ($instituteId) {
$institute = $this->getDoctrine()
->getRepository('OceanExpertBundle:Institutions')
->findOneByIdInst($instituteId);
if ($institute) {
$institute->setActivated(0);
$institute->setLDateUpdated(new DateTime("now"));
$institute->setLastEditBy(
$this->get('security.token_storage')
->getToken()
->getUser()
->getId());
$em = $this->getDoctrine()->getManager();
$em->persist($institute); //marks object to be saved in the next transaction.
$em->flush(); //performs all saves and transactions.
}
return new JsonResponse(
array(
'status' => true,
'msg' => 'updated successfully'
)
);
} else {
return new Response('Cannot update record.');
}
}
return new Response('Cannot update record.');
}
/**
* show this page when the institute has been edited successfully
*
* @param int $idInst
*
* @return Response
*/
public function editInstituteSuccessAction($idInst)
{
return $this->render(
'Institute/editInstituteSuccess.html.twig',
array(
'idInst' => $idInst
)
);
}
/**
* @param Request $request
*
* @return JsonResponse
*/
public function getInstitutionsAjaxAction(Request $request)
{
if (!null == $request->query->get('q')) {
$inst = $request->query->get('q');
$em = $this->getDoctrine()->getManager();
$qb = $em->createQueryBuilder();
$qb->select('i.idInst as id,i.instName');
$qb->from('OceanExpertBundle:Institutions', 'i');
$qb->where('i.instName like :name OR i.acronym like :name');
if (!null == $request->query->get('instId')) {
$qb->andWhere('i.idInst != :instId');
$qb->setParameter('instId', $request->query->get('instId'));
}
$qb->andWhere('i.activated = 1');
$qb->setParameter('name', '%' . $inst . '%');
$qb->setParameter('name', '%' . $inst . '%');
$qb->orderBy('i.instName', 'ASC');
$institutes = $qb->getQuery()->getResult();
$data = array();
if ($institutes) {
$data = array(
'incomplete_results' => false,
'items' => $institutes,
'total_count' => count($institutes),
);
} else {
$data = array(
'incomplete_results' => false,
'items' => array(),
'total_count' => 0,
);
}
return new JsonResponse($data);
}
return new JsonResponse();
}
}

src/OceanExpertBundle/Controller/InstitutionController.php line 1247