public function indexAction()
{
$mainLayout = $this->initializeAdminArea();
$id = $this->params()->fromRoute('id');
$em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default');
$userDetails = $this->layout()->getVariable('userDetails');
$languageSelection = $this->params()->fromRoute('languageSelection');
$modulename = $this->params()->fromRoute('modulename');
try {
$helper = new ContenutiControllerHelper();
$sottoSezioniRecords = $helper->recoverWrapperRecords(new SottoSezioniGetterWrapper(new SottoSezioniGetter($em)), array('showToAll' => $userDetails->role == 'WebMaster' ? null : 1, 'languageAbbreviation' => $languageSelection, 'isAmmTrasparente' => $modulename != 'contenuti' ? 1 : 0));
$helper->checkRecords($sottoSezioniRecords, 'Nessuna sottosezione presente');
$sottoSezioniRecordsForDropDown = $helper->formatSottoSezioniGetterWrapperRecordsForDropdown($sottoSezioniRecords);
$contenutiRecords = $helper->recoverWrapperRecordsById(new ContenutiGetterWrapper(new ContenutiGetter($em)), array('id' => $id, 'isAmmTrasparente' => $modulename != 'contenuti' ? 1 : 0, 'utente' => $userDetails->role == 'WebMaster' ? null : $userDetails->id, 'limit' => 1), $id);
$form = new ContenutiForm();
$form->addSottoSezioni($sottoSezioniRecordsForDropDown);
$form->addMainFormElements();
if ($userDetails->role == 'WebMaster') {
$usersRecords = $helper->recoverWrapperRecords(new UsersGetterWrapper(new UsersGetter($em)), array('orderBy' => 'u.name'));
$arrayToReturn = array();
if (!empty($usersRecords)) {
foreach ($usersRecords as $record) {
$arrayToReturn[$record['id']] = $record['name'] . ' ' . $record['surname'];
}
}
$form->addUsers($arrayToReturn);
}
$form->addHomeBox();
if (!empty($contenutiRecords)) {
$form->setData($contenutiRecords[0]);
$submitButtonValue = 'Modifica';
$formTitle = 'Modifica articolo';
$formDescription = "Modifica i dati relativi all'articolo. Massimo 255 caratteri per i campi testo. Utilizzare testi brevi e concisi. Evitare copia \\ incolla da file word o pagine web che potrebbero pregiudicare l’accessibilità del sito web.";
$formAction = $this->url()->fromRoute('admin/contenuti-update', array('lang' => $this->params()->fromRoute('lang'), 'languageSelection' => $languageSelection, 'modulename' => $modulename));
$formBreadCrumbTitle = '';
} else {
$form->setData(array('dataInserimento' => date('Y-m-d H:i:s'), 'dataScadenza' => date('Y-m-d H:i:s', strtotime('+5 years')), 'attivo' => 1, 'utente' => $userDetails->id));
$form->addSocial();
$formTitle = 'Nuovo articolo';
$formDescription = "Inserisci i dati relativi all'articolo. Massimo 255 caratteri per i campi testo. Utilizzare testi brevi e concisi. Evitare copia \\ incolla da file word o pagine web che potrebbero pregiudicare l’accessibilità del sito web.";
$submitButtonValue = 'Inserisci';
$formAction = $this->url()->fromRoute('admin/contenuti-insert', array('lang' => $this->params()->fromRoute('lang'), 'languageSelection' => $languageSelection, 'modulename' => $modulename));
$formBreadCrumbTitle = 'Nuovo artciolo';
}
$this->layout()->setVariables(array('form' => $form, 'formAction' => $formAction, 'formTitle' => $formTitle, 'formDescription' => $formDescription, 'submitButtonValue' => $submitButtonValue, 'CKEditorField' => array('testo'), 'formBreadCrumbCategory' => ucfirst(str_replace('-', ' ', $modulename)), 'formBreadCrumbCategoryLink' => $this->url()->fromRoute('admin/contenuti-summary', array('lang' => $this->params()->fromRoute('lang'), 'page' => $this->params()->fromRoute('previouspage'), 'languageSelection' => $languageSelection, 'modulename' => $modulename)), 'formBreadCrumbTitle' => $formBreadCrumbTitle, 'templatePartial' => self::formTemplate));
} catch (\Exception $e) {
$this->layout()->setVariables(array('messageType' => 'warning', 'messageTitle' => 'Errore verificato', 'messageText' => 'Messaggio generato ' . $e->getMessage(), 'templatePartial' => 'message.phtml'));
}
$this->layout()->setTemplate($mainLayout);
}
public function indexAction()
{
$mainLayout = $this->initializeAdminArea();
$em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default');
$id = $this->params()->fromRoute('id');
$helper = new ContenutiControllerHelper();
$contenutiRecords = $helper->recoverWrapperRecordsById(new ContenutiGetterWrapper(new ContenutiGetter($em)), array('id' => $id, 'limit' => 1, 'fields' => 'contenuti.id, contenuti.titolo, contenuti.tabella'), $id);
$form = new ContenutiTabellaForm();
$formAction = $this->url()->fromRoute('admin/amministrazione-trasparente-tabella-update', array('lang' => $this->params()->fromRoute('lang'), 'languageSelection' => $this->params()->fromRoute('languageSelection'), 'modulename' => 'amministrazione-trasparente'));
$formTitle = $contenutiRecords[0]['titolo'];
$formDescription = "Compila i dati della tabella (dati aggiuntivi all'articolo)";
if (!empty($contenutiRecords[0])) {
$form->setData($contenutiRecords[0]);
}
$this->layout()->setVariables(array('form' => $form, 'formAction' => $formAction, 'formTitle' => $formTitle, 'formDescription' => $formDescription, 'submitButtonValue' => 'Aggiorna', 'CKEditorField' => array('tabella'), 'formBreadCrumbCategory' => array(array('href' => $this->url()->fromRoute('admin/contenuti-summary', array('lang' => $this->params()->fromRoute('lang'), 'languageSelection' => $this->params()->fromRoute('languageSelection'), 'modulename' => 'amministrazione-trasparente')), 'label' => 'Amministrazione Trasparente', 'title' => 'Vai alla gestione amministrazione Trasparente'), array('href' => '#', 'label' => 'Articolo', 'title' => "Vai alla gestione dell'articolo")), 'formBreadCrumbTitle' => 'Gestione tabella aggiuntiv', 'templatePartial' => self::formTemplate));
$this->layout()->setTemplate($mainLayout);
}
public function indexAction()
{
$id = $this->params()->fromPost('id');
/**
* @var \Doctrine\ORM\EntityManager $em
*/
$em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default');
/**
* @var \Doctrine\DBAL\Connection $connection
*/
$connection = $em->getConnection();
$request = $this->getRequest();
$post = array_merge_recursive($request->getPost()->toArray(), $request->getFiles()->toArray());
if (!($request->isXmlHttpRequest() or $request->isPost())) {
return $this->redirect()->toRoute('main');
}
$mainLayout = $this->initializeAdminArea();
$configurations = $this->layout()->getVariable('configurations');
$userDetails = $this->recoverUserDetails();
$moduleId = $this->params()->fromRoute('modulename') == 'contenuti' ? ModulesContainer::contenuti_id : ModulesContainer::amministrazione_trasparente_id;
$helper = new ContenutiControllerHelper();
try {
$contentRecord = $helper->recoverWrapperRecordsById(new ContenutiGetterWrapper(new ContenutiGetter($em)), array('id' => $post['deleteId'], 'limit' => 1), $post['deleteId']);
$helper->checkRecords($contentRecord, 'Articolo da eliminare non trovato');
$helper->setConnection($connection);
$helper->getConnection()->beginTransaction();
$helper->delete($post['deleteId']);
$helper->getConnection()->commit();
/* Delte Attachments files */
$attachmentsHelper = new AttachmentsControllerHelper();
$attachmentsHelper->setConnection($connection);
$attachmentsRecords = $helper->recoverWrapperRecords(new AttachmentsGetterWrapper(new AttachmentsGetter($em)), array('referenceId' => $post['deleteId'], 'moduleId' => $moduleId));
if (!empty($attachmentsRecords)) {
foreach ($attachmentsRecords as $attachmentRecord) {
$attachmentsHelper->deleteAttachments($attachmentsRecords['id']);
$attachmentsHelper->deleteAttachmentsRelations($attachmentsRecords['id']);
$s3 = new S3($configurations['amazon_s3_accesskey'], $configurations['amazon_s3_secretkey']);
$s3->deleteObject($configurations['amazon_s3_bucket'], $this->params()->fromRoute('modulename') . '/' . $attachmentRecord[0]['name']);
}
}
/* Delete from home page */
$homeHelper = new HomePagePutRemoveControllerHelper();
$homePageRecords = $homeHelper->recoverWrapperRecords(new HomePageGetterWrapper(new HomePageGetter($em)), array('referenceId' => $post['deleteId'], 'moduleId' => $moduleId, 'moduleCode' => $this->params()->fromRoute('modulename')));
if (!empty($homePageRecords)) {
$homePageBlocksRecords = $helper->recoverWrapperRecords(new HomePageBlocksGetterWrapper(new HomePageBlocksGetter($em)), array('fields' => 'homePageBlocks.id', 'moduleId' => $moduleId, 'limit' => 1));
$helper->checkRecords($homePageBlocksRecords, 'Impossibile recuperare i dati relativi al modulo in home page');
$homeHelper->setConnection($connection);
$homeHelper->getConnection()->beginTransaction();
$homeHelper->deleteFromHomePage($post['deleteId'], $homePageBlocksRecords[0]['id']);
$homeHelper->getConnection()->commit();
}
$logWriter = new LogWriter($connection);
$logWriter->writeLog(array('user_id' => $userDetails->id, 'module_id' => ModulesContainer::recoverIdFromModuleCode($this->params()->fromRoute('modulename')), 'message' => "Eliminato articolo " . $contentRecord[0]['titolo'], 'type' => 'info', 'reference_id' => $id, 'backend' => 1));
$referer = $this->getRequest()->getHeader('Referer');
if (is_object($referer)) {
return $this->redirect()->toUrl($referer->getUri());
}
} catch (\Exception $e) {
try {
// $helper->getConnection()->rollBack();
} catch (\Doctrine\DBAL\ConnectionException $dbEx) {
}
$logWriter = new LogWriter($connection);
$logWriter->writeLog(array('user_id' => $userDetails->id, 'module_id' => ModulesContainer::contenuti_id, 'message' => "Errore eliminazione file articolo ", 'type' => 'error', 'description' => $e->getMessage(), 'reference_id' => $id, 'backend' => 1));
$referer = $this->getRequest()->getHeader('Referer');
if (is_object($referer)) {
$refererLink = $referer->getUri();
}
$this->layout()->setVariables(array('messageType' => 'danger', 'messageTitle' => 'Errore eliminazione contenuto', 'messageText' => $e->getMessage(), 'previousPageLink' => isset($refererLink) ? $refererLink : null, 'previousPageLabel' => "Torna all'elenco", 'templatePartial' => "message.phtml"));
}
$this->layout()->setTemplate($mainLayout);
}