public function updatecolumnattachmentAction()
 {
     $request = $this->getRequest();
     $post = array_merge_recursive($request->getPost()->toArray(), $request->getFiles()->toArray());
     if ($request->isPost()) {
         /**
          * @var \Doctrine\ORM\EntityManager $em
          */
         $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default');
         /**
          * @var \Doctrine\DBAL\Connection $connection
          */
         $connection = $em->getConnection();
         $inputFilter = new AttiConcessioneColumnDisplayFormInputFilter();
         $form = new AttiConcessioneColumnDisplayForm();
         $form->addSubmitButton();
         $form->setInputFilter($inputFilter->getInputFilter());
         $form->setData($post);
         if ($form->isValid()) {
             $inputFilter->exchangeArray($form->getData());
             $helper = new AttachmentsControllerHelper();
             $helper->setConnection($connection);
             $helper->getConnection()->beginTransaction();
             $helper->updateAttiConcessioneColonna($post['id'], $post['attiConcessioneColonna']);
             $helper->getConnection()->commit();
         }
         if (is_object($this->getRequest()->getHeader('Referer'))) {
             return $this->redirect()->toUrl($this->getRequest()->getHeader('Referer')->getUri());
         }
         return $this->redirectForUnvalidAccess();
     }
 }
 public function indexAction()
 {
     $appServiceLoader = $this->recoverAppServiceLoader();
     $items = $this->params()->fromQuery('oggettoItem');
     /**
      * @var \Doctrine\DBAL\Connection
      */
     $connection = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default')->getConnection();
     $this->initializeAdminArea();
     $helper = new AttachmentsControllerHelper();
     $helper->setConnection($connection);
     $helper->getConnection()->beginTransaction();
     try {
         if (!empty($items)) {
             foreach ($items as $position => $item) {
                 $helper->updatePosition($item, $position);
             }
         }
         $helper->getConnection()->commit();
         $this->layout()->setTerminal(true);
         $backendTemplate = $appServiceLoader->recoverServiceKey('configurations', 'template_backend');
         $this->layout('backend/templates/' . $backendTemplate . 'sezioni/positions_message.phtml');
     } catch (\Exception $e) {
         try {
             $helper->getConnection()->rollBack();
         } catch (\Doctrine\DBAL\ConnectionException $dbEx) {
         }
         echo $e->getMessage();
         exit;
     }
 }
 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();
     $userDetails = $this->recoverUserDetails();
     $helper = new AttachmentsControllerHelper();
     $helper->setConnection($connection);
     $helper->getConnection()->beginTransaction();
     try {
         $helper->setLoggedUser($userDetails);
         $attachmentRecord = $helper->recoverWrapperRecordsById(new AttachmentsGetterWrapper(new AttachmentsGetter($em)), array('id' => $post['deleteId'], 'limit' => 1), $post['deleteId']);
         $helper->checkRecords($attachmentRecord, 'Dati file allegato non trovati');
         $configurations = $this->layout()->getVariable('configurations');
         $s3 = new S3($configurations['amazon_s3_accesskey'], $configurations['amazon_s3_secretkey']);
         $s3->deleteObject($configurations['amazon_s3_bucket'], $this->params()->fromRoute('modulename') . '/' . $attachmentRecord[0]['name']);
         $helper->deleteAttachments($post['deleteId']);
         $helper->deleteAttachmentsRelations($post['deleteId']);
         $logWriter = new LogWriter($connection);
         $logWriter->writeLog(array('user_id' => $userDetails->id, 'module_id' => ModulesContainer::recoverIdFromModuleCode($this->params()->fromRoute('modulename')), 'message' => "Eliminato file allegato ", 'type' => 'info', 'reference_id' => $id, 'backend' => 1));
         $helper->getConnection()->commit();
         $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 allegato", '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 file allegato', 'messageText' => $e->getMessage(), 'previousPageLink' => isset($refererLink) ? $refererLink : null, 'previousPageLabel' => "Torna all'elenco allegati", 'templatePartial' => "message.phtml"));
     }
     $this->layout()->setTemplate($mainLayout);
 }
 public function indexAction()
 {
     /**
      * @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');
     }
     $inputFilter = new AttachmentsFormInputFilter();
     $form = new AttachmentsForm();
     $form->setBindOnValidate(false);
     $form->setInputFilter($inputFilter->getInputFilter());
     $form->setData($post);
     $this->initializeAdminArea();
     $userDetails = $this->recoverUserDetails();
     try {
         if (!$form->isValid()) {
             throw new NullException("The form is not valid");
         }
         $inputFilter->exchangeArray($form->getData());
         $helper = new AttachmentsControllerHelper();
         $helper->setConnection($connection);
         $helper->getConnection()->beginTransaction();
         $helper->setLoggedUser($userDetails);
         //$helper->updateOptions($inputFilter);
         $helper->getConnection()->commit();
         $logWriter = new LogWriter($connection);
         $logWriter->writeLog(array('user_id' => $userDetails->id, 'module_id' => ModulesContainer::contenuti_id, 'message' => "Aggiornato file allegato " . $inputFilter->title, 'type' => 'info', 'reference_id' => $inputFilter->id, 'backend' => 1));
         $this->layout()->setVariables(array('messageType' => 'success', 'messageTitle' => 'Allegato aggiornato correttamente', 'messageText' => 'I dati sono stati processati correttamente dal sistema', 'messageShowFormLink' => 1, 'messageShowForm' => "Torna ai dati dell'allegato", 'backToSummaryText' => "Elenco allegati"));
         $this->layout()->setTemplate($this->layout()->getVariable('templateDir') . 'message.phtml');
     } catch (\Exception $e) {
         $logWriter = new LogWriter($connection);
         $logWriter->writeLog(array('user_id' => $userDetails->id, 'module_id' => ModulesContainer::contenuti_id, 'message' => "Errore aggiornamento file allegato", 'type' => 'error', 'description' => $e->getMessage(), 'reference_id' => $inputFilter->id, 'backend' => 1));
         $this->layout()->setVariables(array('messageType' => 'danger', 'messageTitle' => 'Errore aggiornamento file allegato', 'messageText' => $e->getMessage(), 'form' => $form, 'formInputFilter' => $inputFilter->getInputFilter(), 'messageShowFormLink' => 1, 'messageShowForm' => 'Torna al file allegato'));
         $this->layout()->setTemplate($this->layout()->getVariable('templateDir') . 'message.phtml');
     }
 }
 public function indexAction()
 {
     /**
      * @var \Doctrine\ORM\EntityManager $em
      */
     $em = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default');
     /**
      * @var \Doctrine\DBAL\Connection $connection
      */
     $connection = $em->getConnection();
     $request = $this->getRequest();
     if (!($request->isXmlHttpRequest() or $request->isPost())) {
         return $this->redirect()->toRoute('main');
     }
     $post = array_merge_recursive($request->getPost()->toArray(), $request->getFiles()->toArray());
     $inputFilter = new AttachmentsFormInputFilter();
     $moduleCode = $this->params()->fromRoute('modulename');
     $form = new AttachmentsForm();
     $form->setBindOnValidate(false);
     $form->setInputFilter($inputFilter->getInputFilter());
     $form->setData($post);
     $this->initializeAdminArea();
     $userDetails = $this->recoverUserDetails();
     $helper = new AttachmentsControllerHelper();
     $helper->setConnection($connection);
     $helper->getConnection()->beginTransaction();
     $s3Helper = new S3Helper();
     try {
         if (!$form->isValid()) {
             throw new NullException("The form is not valid");
         }
         $inputFilter->exchangeArray($form->getData());
         $helper->setLoggedUser($userDetails);
         $configurations = $this->layout()->getVariable('configurations');
         $s3AccessKey = isset($configurations['amazon_s3_accesskey']) ? $configurations['amazon_s3_accesskey'] : null;
         $s3SecretKey = isset($configurations['amazon_s3_secretkey']) ? $configurations['amazon_s3_secretkey'] : null;
         $s3Helper->setAccessKey($s3AccessKey);
         $s3Helper->setSecretKey($s3SecretKey);
         $s3Helper->setBucket(isset($configurations['amazon_s3_bucket']) ? $configurations['amazon_s3_bucket'] : null);
         $s3Helper->setS3Directory($inputFilter->s3_directory);
         $s3Helper->setS3(new S3($s3AccessKey, $s3SecretKey));
         $mimeRecords = $helper->recoverWrapperRecords(new AttachmentsMimetypeGetterWrapper(new AttachmentsMimetypeGetter($em)), array('mimetype' => $inputFilter->attachmentFile['type'], 'limit' => 1));
         $helper->checkRecords($mimeRecords, "Il tipo di file inserito non è supportato. Per ulteriori informazioni contattare l'amministrazione");
         $lastInsertId = $helper->insertAttachments($inputFilter, $mimeRecords[0]['id']);
         $attachmentFileName = $s3Helper->assignFileName($inputFilter->attachmentFile['name'], $lastInsertId);
         $helper->updateAttachmentsFilename($lastInsertId, $attachmentFileName);
         $helper->insertAttachmentsRelations($inputFilter, $lastInsertId);
         $s3Helper->upload($inputFilter->attachmentFile['tmp_name'], $attachmentFileName);
         $logWriter = new LogWriter($connection);
         $logWriter->writeLog(array('user_id' => $userDetails->id, 'module_id' => ModulesContainer::recoverIdFromModuleCode($moduleCode), 'message' => "Inserito nuovo allegato " . $inputFilter->title, 'type' => 'info', 'reference_id' => $lastInsertId, 'backend' => 1));
         $this->layout()->setVariables(array('messageType' => 'success', 'messageTitle' => 'Allegato inserito correttamente', 'messageText' => 'I dati sono stati processati correttamente dal sistema', 'showLinkResetFormAndShowIt' => 1, 'backToSummaryText' => "Elenco file allegati", 'insertAgainLabel' => "Inserisci un altro file allegato", 'attachmentsLabel' => 'Elenco allegati', 'attachmentsLink' => $this->url()->fromRoute('admin/attachments-summary', array('lang' => $this->params()->fromRoute('lang'), 'module' => $moduleCode, 'referenceId' => $inputFilter->referenceId))));
         $helper->getConnection()->commit();
     } 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::recoverIdFromModuleCode($moduleCode), 'message' => "Errore inserimento nuovo file allegato: " . $inputFilter->title, 'type' => 'error', 'description' => $e->getMessage(), 'backend' => 1));
         $this->layout()->setVariables(array('messageType' => 'danger', 'messageTitle' => 'Errore inserimento file allegato', 'messageText' => $e->getMessage(), 'form' => $form, 'formInputFilter' => $inputFilter->getInputFilter(), 'messageShowFormLink' => 1, 'messageShowForm' => 'Torna al form di inserimento dati'));
     }
     $this->layout()->setTemplate($this->layout()->getVariable('templateDir') . 'message.phtml');
 }
 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);
 }