PHP Util::getAssetsFolder方法代码示例

 public function indexAction(Request $request, SessionInterface $session)
 {
     Util::checkUserIsLoggedInAndRedirect();
     $loggedInUserId = $session->get('user/id');
     $name = $request->request->get('name');
     $description = $request->request->get('description');
     $type = $request->request->get('type');
     $parentId = $request->request->get('parent_id');
     $spaceId = $request->request->get('space_id');
     if ($type == 'file_list') {
         $pageType = EntityType::ENTITY_FILE_LIST;
     } else {
         $pageType = EntityType::ENTITY_BLANK_PAGE;
     }
     if ($parentId == -1) {
         // set the parent to the home page of the space if it exists
         $space = $this->getRepository(Space::class)->getById($spaceId);
         $homeEntityId = $space['home_entity_id'];
         if ($homeEntityId) {
             $parentId = $homeEntityId;
         } else {
             $parentId = null;
         }
     }
     $page = new Entity($pageType, $spaceId, $loggedInUserId, $parentId, $name, $description);
     $currentDate = Util::getServerCurrentDateTime();
     $pageId = $page->save($currentDate);
     // if the page is a file list create the folders
     $baseFilePath = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_DOCUMENTADOR, 'filelists');
     if ($pageType == EntityType::ENTITY_FILE_LIST) {
         mkdir($baseFilePath . $pageId);
     }
     return new Response($pageId);
 }

 public function indexAction(Request $request, SessionInterface $session)
 {
     Util::checkUserIsLoggedInAndRedirect();
     $clientId = $session->get('client/id');
     $loggedInUserId = $session->get('user/id');
     $entityId = $request->get('id');
     $currentDate = Util::getServerCurrentDateTime();
     $pathBaseAttachments = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_DOCUMENTADOR, 'filelists');
     $index = 0;
     if (isset($_FILES['entity_upload_file'])) {
         foreach ($_FILES['entity_upload_file']['name'] as $filename) {
             if (!empty($filename)) {
                 // check if this file already exists
                 $fileExists = $this->getRepository(Entity::class)->getFileByName($entityId, $filename);
                 if ($fileExists) {
                     // get the last revision and increment it by one
                     $fileId = $fileExists['id'];
                     $revisions = $this->getRepository(Entity::class)->getRevisionsByFileId($fileId);
                     $revisionNumber = $revisions->num_rows + 1;
                     // create the revision folder
                     if (!file_exists($pathBaseAttachments . $entityId)) {
                         mkdir($pathBaseAttachments . $entityId);
                     }
                     if (!file_exists($pathBaseAttachments . $entityId . '/' . $fileId)) {
                         mkdir($pathBaseAttachments . $entityId . '/' . $fileId);
                     }
                     if (!file_exists($pathBaseAttachments . $entityId . '/' . $fileId . '/' . $revisionNumber)) {
                         mkdir($pathBaseAttachments . $entityId . '/' . $fileId . '/' . $revisionNumber);
                     }
                 } else {
                     // add the file to the list of files
                     $fileId = $this->getRepository(Entity::class)->addFile($entityId, $filename, $currentDate);
                     $this->getLogger()->addInfo('ADD Documentador entity file ' . $filename, $this->getLoggerContext());
                     $revisionNumber = 1;
                     // create the folder for the file
                     mkdir($pathBaseAttachments . $entityId . '/' . $fileId);
                     // create the folder for the first revision
                     mkdir($pathBaseAttachments . $entityId . '/' . $fileId . '/' . $revisionNumber);
                 }
                 // add revision to the file
                 $this->getRepository(Entity::class)->addFileRevision($fileId, $loggedInUserId, $currentDate);
                 if ($revisionNumber > 1) {
                     $this->getLogger()->addInfo('ADD Documentador entity file revision to ' . $filename, $this->getLoggerContext());
                 }
                 $baseFileName = pathinfo($filename, PATHINFO_FILENAME);
                 $extension = pathinfo($filename, PATHINFO_EXTENSION);
                 move_uploaded_file($_FILES["entity_upload_file"]["tmp_name"][$index], $pathBaseAttachments . $entityId . '/' . $fileId . '/' . $revisionNumber . '/' . $baseFileName . '.' . $extension);
                 $index++;
             }
         }
     }
     return new RedirectResponse('/documentador/page/view/' . $entityId);
 }

 public function indexAction(Request $request, SessionInterface $session)
 {
     Util::checkUserIsLoggedInAndRedirect();
     $loggedInUserId = $session->get('user/id');
     $CKEditorFuncNum = $_GET['CKEditorFuncNum'];
     $allowedExtensions = array("gif", "jpeg", "jpg", "png");
     $extension = strtolower(pathinfo($_FILES['upload']['name'], PATHINFO_EXTENSION));
     $entityId = $session->get('current_edit_entity_id');
     $entity = $this->getRepository(Entity::class)->getById($entityId);
     $spaceId = $entity['space_id'];
     $currentDate = Util::getServerCurrentDateTime();
     $attachmentsBaseFilePath = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_DOCUMENTADOR, 'attachments');
     if (($_FILES["upload"]["type"] == "image/gif" || $_FILES["upload"]["type"] == "image/jpeg" || $_FILES["upload"]["type"] == "image/jpg" || $_FILES["upload"]["type"] == "image/pjpeg" || $_FILES["upload"]["type"] == "image/x-png" || $_FILES["upload"]["type"] == "image/png") && in_array($extension, $allowedExtensions)) {
         if ($_FILES["upload"]["error"] > 0) {
             // error
         } else {
             $fileName = $_FILES["upload"]["name"];
             // check if the attachment already exists
             $attachment = $this->getRepository(EntityAttachment::class)->getByEntityIdAndName($entityId, $fileName);
             if ($attachment) {
                 // get the last revision and increment it by one
                 $attachmentId = $attachment['id'];
                 $revisions = $this->getRepository(Entity::class)->getRevisionsByAttachmentId($attachmentId);
                 $revisionNumber = $revisions->num_rows + 1;
                 // create the revision folder
                 mkdir($attachmentsBaseFilePath . $spaceId . '/' . $entityId . '/' . $attachmentId . '/' . $revisionNumber);
             } else {
                 // add the attachment in the database
                 $currentDate = Util::getServerCurrentDateTime();
                 $attachmentId = $this->getRepository(EntityAttachment::class)->add($entityId, $fileName, $currentDate);
                 $revisionNumber = 1;
                 if (!file_exists($attachmentsBaseFilePath . $spaceId)) {
                     mkdir($attachmentsBaseFilePath . $spaceId);
                 }
                 if (!file_exists($attachmentsBaseFilePath . $spaceId . '/' . $entityId)) {
                     mkdir($attachmentsBaseFilePath . $spaceId . '/' . $entityId);
                 }
                 if (!file_exists($attachmentsBaseFilePath . $spaceId . '/' . $entityId . '/' . $attachmentId)) {
                     mkdir($attachmentsBaseFilePath . $spaceId . '/' . $entityId . '/' . $attachmentId);
                 }
                 mkdir($attachmentsBaseFilePath . $spaceId . '/' . $entityId . '/' . $attachmentId . '/' . $revisionNumber);
             }
             $directoryName = $attachmentsBaseFilePath . $spaceId . '/' . $entityId . '/' . $attachmentId . '/' . $revisionNumber;
             move_uploaded_file($_FILES["upload"]["tmp_name"], $directoryName . '/' . $fileName);
             $this->getRepository(EntityAttachment::class)->addRevision($attachmentId, $loggedInUserId, $currentDate);
             $attachmentsPath = UbirimiContainer::get()['asset.documentador_entity_attachments'];
             $html = '<html><body><script type="text/javascript">window.parent.CKEDITOR.tools.callFunction("' . $CKEditorFuncNum . '", "/assets/' . $attachmentsPath . $spaceId . '/' . $entityId . '/' . $attachmentId . '/' . $revisionNumber . '/' . $fileName . '");</script></body></html>';
             return new Response($html);
         }
     } else {
         return new Response('');
     }
 }

 public function indexAction(Request $request, SessionInterface $session)
 {
     Util::checkUserIsLoggedInAndRedirect();
     $loggedInUserId = $session->get('user/id');
     $filenameData = apache_request_headers();
     $filename = rawurldecode($filenameData['X_FILENAME']);
     $issueId = $request->request->get('issue_id');
     if (!$session->has('added_attachments_in_screen')) {
         $session->set('added_attachments_in_screen', array());
     }
     /* every attachment has its own dedicated sub-folder, so no editing on the upload filename will be done */
     if ($filename) {
         $ext = substr($filename, strrpos($filename, '.') + 1);
         $filenameWithoutExtension = substr($filename, 0, strrpos($filename, '.'));
         $attachmentId = $this->getRepository(IssueAttachment::class)->add($issueId, Util::slugify($filenameWithoutExtension) . '.' . $ext, $loggedInUserId, Util::getServerCurrentDateTime());
         if ($issueId == null) {
             $issueId = 'user_' . $loggedInUserId;
         }
         $uploadDirectory = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId;
         /* subfolders */
         $uploadDirSubfolder = $uploadDirectory . '/' . $attachmentId;
         if (!file_exists($uploadDirectory)) {
             mkdir($uploadDirectory);
         }
         if (!file_exists($uploadDirSubfolder)) {
             mkdir($uploadDirSubfolder);
         }
         $newFileName = $uploadDirSubfolder . '/' . Util::slugify($filenameWithoutExtension) . '.' . $ext;
         file_put_contents($newFileName, file_get_contents('php://input'));
         $size = filesize($newFileName);
         $temp = $session->get('added_attachments_in_screen');
         $temp[] = $attachmentId;
         $session->set('added_attachments_in_screen', $temp);
         $this->getRepository(IssueAttachment::class)->updateSizeById($attachmentId, $size);
         if (Util::isImage(Util::getExtension($filename))) {
             $thumbUploaddirSubfolder = $uploadDirSubfolder . '/thumbs';
             if (!file_exists($thumbUploaddirSubfolder)) {
                 mkdir($thumbUploaddirSubfolder);
             }
             $newThumbnailName = $thumbUploaddirSubfolder . '/' . Util::slugify($filenameWithoutExtension) . '.' . $ext;
             $image = new ZebraImage();
             $image->jpeg_quality = 100;
             $image->chmod_value = 0755;
             $image->source_path = $newFileName;
             $image->target_path = $newThumbnailName;
             $image->resize(150, 150, ZEBRA_IMAGE_CROP_CENTER);
         }
         return new JsonResponse($attachmentId);
     }
     return new Response('');
 }

 public function indexAction(Request $request, SessionInterface $session)
 {
     $loggedInUserId = UbirimiContainer::get()['session']->get('user/id');
     Util::checkUserIsLoggedInAndRedirect();
     $issueId = $request->request->get('issue_id');
     $attIdsSession = $session->has('added_attachments_in_screen') ? $session->get('added_attachments_in_screen') : null;
     if ($attIdsSession) {
         for ($i = 0; $i < count($attIdsSession); $i++) {
             $attachmentId = $attIdsSession[$i];
             $this->getRepository(IssueAttachment::class)->deleteById($attachmentId);
             if ($issueId) {
                 Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId . '/' . $attachmentId);
             }
         }
         $session->remove('added_attachments_in_screen');
     }
     if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId)) {
         Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId);
     }
     return new Response('');
 }

 public function indexAction(Request $request, SessionInterface $session)
 {
     Util::checkUserIsLoggedInAndRedirect();
     $clientId = $session->get('client/id');
     $loggedInUserId = $session->get('user/id');
     $attachmentId = $request->request->get('id');
     $attachment = $this->getRepository(EntityAttachment::class)->getById($attachmentId);
     $entityId = $attachment['documentator_entity_id'];
     $space = $this->getRepository(Entity::class)->getById($entityId);
     $spaceId = $space['space_id'];
     $currentDate = Util::getServerCurrentDateTime();
     $this->getRepository(EntityAttachment::class)->deleteById($spaceId, $entityId, $attachmentId);
     $this->getLogger()->addInfo('DELETE Documentador entity attachment ' . $attachment['name'], $this->getLoggerContext());
     $attachments = $this->getRepository(EntityAttachment::class)->getByEntityId($entityId);
     if (!$attachments) {
         // delete the attachment folder
         $attachmentsFilePath = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_DOCUMENTADOR, 'attachments');
         Util::deleteDir($attachmentsFilePath . $spaceId . '/' . $entityId);
     }
     return new Response('');
 }

 public function deleteById($spaceId, $entityId, $attachmentId)
 {
     EntityAttachment::deleteRevisionsByAttachmentId($attachmentId);
     // delete folder from disk
     $attachmentsFilePath = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_DOCUMENTADOR, 'attachments');
     Util::deleteDir($attachmentsFilePath . $spaceId . '/' . $entityId . '/' . $attachmentId);
     // remove attachment revisions
     $query = "delete from documentator_entity_attachment where id = ? limit 1";
     if ($stmt = UbirimiContainer::get()['db.connection']->prepare($query)) {
         $stmt->bind_param("i", $attachmentId);
         $stmt->execute();
     }
 }

 public function deleteById($clientId)
 {
     $clientData = UbirimiContainer::get()['repository']->get(UbirimiClient::class)->getById($clientId);
     $query = "SET FOREIGN_KEY_CHECKS = 0;";
     UbirimiContainer::get()['db.connection']->query($query);
     // delete Yongo Product data
     $projects = UbirimiContainer::get()['repository']->get(UbirimiClient::class)->getProjects($clientId);
     while ($projects && ($project = $projects->fetch_array(MYSQLI_ASSOC))) {
         UbirimiContainer::get()['repository']->get(YongoProject::class)->deleteById($project['id']);
     }
     $workflows = UbirimiContainer::get()['repository']->get(Workflow::class)->getByClientId($clientId);
     while ($workflows && ($workflow = $workflows->fetch_array(MYSQLI_ASSOC))) {
         UbirimiContainer::get()['repository']->get(Workflow::class)->deleteById($workflow['id']);
     }
     UbirimiContainer::get()['repository']->get(NotificationScheme::class)->deleteByClientId($clientId);
     $screens = UbirimiContainer::get()['repository']->get(Screen::class)->getByClientId($clientId);
     while ($screens && ($screen = $screens->fetch_array(MYSQLI_ASSOC))) {
         UbirimiContainer::get()['repository']->get(Screen::class)->deleteById($screen['id']);
     }
     UbirimiContainer::get()['repository']->get(NotificationScheme::class)->deleteByClientId($clientId);
     UbirimiContainer::get()['repository']->get(UbirimiClient::class)->deleteYongoIssueTypes($clientId);
     UbirimiContainer::get()['repository']->get(UbirimiClient::class)->deleteYongoIssueStatuses($clientId);
     UbirimiContainer::get()['repository']->get(UbirimiClient::class)->deleteYongoIssueResolutions($clientId);
     UbirimiContainer::get()['repository']->get(UbirimiClient::class)->deleteYongoIssuePriorities($clientId);
     UbirimiContainer::get()['repository']->get(Field::class)->deleteByClientId($clientId);
     UbirimiContainer::get()['repository']->get(FieldConfiguration::class)->deleteByClientId($clientId);
     UbirimiContainer::get()['repository']->get(FieldConfigurationScheme::class)->deleteByClientId($clientId);
     UbirimiContainer::get()['repository']->get(NotificationScheme::class)->deleteByClientId($clientId);
     UbirimiContainer::get()['repository']->get(NotificationScheme::class)->deleteByClientId($clientId);
     UbirimiContainer::get()['repository']->get(IssueTypeScheme::class)->deleteByClientId($clientId);
     UbirimiContainer::get()['repository']->get(IssueTypeScreenScheme::class)->deleteByClientId($clientId);
     // delete issue security schemes
     $issueSecuritySchemes = UbirimiContainer::get()['repository']->get(IssueSecurityScheme::class)->getByClientId($clientId);
     while ($issueSecuritySchemes && ($issueSecurityScheme = $issueSecuritySchemes->fetch_array(MYSQLI_ASSOC))) {
         UbirimiContainer::get()['repository']->get(IssueSecurityScheme::class)->deleteById($issueSecurityScheme['id']);
     }
     $users = UbirimiContainer::get()['repository']->get(UbirimiClient::class)->getUsers($clientId);
     if ($users) {
         $userIdsArray = array();
         while ($user = $users->fetch_array(MYSQLI_ASSOC)) {
             $userIdsArray[] = $user['id'];
             // delete user avatars
             $spaceBasePath = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_GENERAL_SETTINGS, 'user_avatars');
             Util::deleteDir($spaceBasePath . $user['id']);
         }
         $users_ids_string = implode($userIdsArray, ', ');
         $query = 'delete from general_group_data where user_id IN (' . $users_ids_string . ')';
         UbirimiContainer::get()['db.connection']->query($query);
         $query = 'delete from permission_role_data where default_user_id IN (' . $users_ids_string . ')';
         UbirimiContainer::get()['db.connection']->query($query);
     }
     UbirimiContainer::get()['repository']->get(UbirimiClient::class)->deleteGroups($clientId);
     $query = 'delete from permission_role where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     $query = 'delete from general_user where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     $query = 'delete from event where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     $query = 'delete from client_product where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     $query = 'delete from client_yongo_settings where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     $query = 'delete from client_documentator_settings where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     $query = 'delete from client_smtp_settings where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     $query = 'delete from client_settings where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     $query = 'delete from general_log where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     $query = 'delete from sys_permission_global_data where client_id = ' . $clientId;
     UbirimiContainer::get()['db.connection']->query($query);
     // delete Cheetah Product data
     $agileBoards = UbirimiContainer::get()['repository']->get(Board::class)->getByClientId($clientId, 'array');
     if ($agileBoards) {
         for ($i = 0; $i < count($agileBoards); $i++) {
             UbirimiContainer::get()['repository']->get(Board::class)->deleteById($agileBoards[$i]['id']);
         }
     }
     // delete Events Product data
     UbirimiContainer::get()['repository']->get(UbirimiClient::class)->deleteCalendars($clientId);
     // delete SVN Product data
     UbirimiContainer::get()['repository']->get(UbirimiClient::class)->deleteSVNRepositories($clientId);
     // delete Documentador Product data
     UbirimiContainer::get()['repository']->get(UbirimiClient::class)->deleteSpaces($clientId);
     $query = 'delete from client where id = ' . $clientId . ' limit 1';
     UbirimiContainer::get()['db.connection']->query($query);
     // also delete paymill information
     $client = new PaymillClient();
     $client->setId($clientData['paymill_id']);
     $requestPaymill = new PaymillRequest(UbirimiContainer::get()['paymill.private_key']);
     $response = $requestPaymill->delete($client);
     $query = "SET FOREIGN_KEY_CHECKS = 1;";
     UbirimiContainer::get()['db.connection']->query($query);
 }

 public function deleteFilesByEntityId($entityId)
 {
     $files = Entity::getFilesByEntityId($entityId);
     if ($files) {
         while ($file = $files->fetch_array(MYSQLI_ASSOC)) {
             // delete the revisions
             Entity::deleteFileRevisions($file['id']);
         }
     }
     // delete folder from disk
     $filelistsPathBase = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_DOCUMENTADOR, 'filelists');
     Util::deleteDir($filelistsPathBase . $entityId);
     // remove file from database
     $query = "delete from documentator_entity_file where documentator_entity_id = ?";
     if ($stmt = UbirimiContainer::get()['db.connection']->prepare($query)) {
         $stmt->bind_param("i", $entityId);
         $stmt->execute();
     }
 }

 public function deleteByIssueId($issueId)
 {
     $attachments = IssueAttachment::getByIssueId($issueId);
     if ($attachments) {
         while ($attachment = $attachments->fetch_array(MYSQLI_ASSOC)) {
             $attachmentId = $attachment['id'];
             unlink(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId . '/' . $attachmentId . '/' . $attachment['name']);
             if (Util::isImage(Util::getExtension($attachment['name']))) {
                 unlink(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId . '/' . $attachmentId . '/thumbs/' . $attachment['name']);
                 Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId . '/' . $attachmentId . '/thumbs');
             }
             Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId . '/' . $attachmentId);
         }
         // also delete the folder
         if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId)) {
             Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId);
         }
     }
 }

 public function deleteById($spaceId)
 {
     $spaceEntities = UbirimiContainer::get()['repository']->get(Entity::class)->getAllBySpaceId($spaceId);
     if ($spaceEntities) {
         while ($spaceEntity = $spaceEntities->fetch_array(MYSQLI_ASSOC)) {
             UbirimiContainer::get()['repository']->get(EntityComment::class)->deleteCommentsByEntityId($spaceEntity['id']);
             UbirimiContainer::get()['repository']->get(Entity::class)->removeAsFavouriteForUsers($spaceEntity['id']);
             UbirimiContainer::get()['repository']->get(Entity::class)->deleteRevisionsByEntityId($spaceEntity['id']);
             UbirimiContainer::get()['repository']->get(Entity::class)->deleteFilesByEntityId($spaceEntity['id']);
             UbirimiContainer::get()['repository']->get(EntityAttachment::class)->deleteByEntityId($spaceEntity['id'], $spaceId);
             UbirimiContainer::get()['repository']->get(Entity::class)->deleteById($spaceEntity['id']);
             // delete any files, if any
             $spaceBasePath = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_DOCUMENTADOR, 'filelists');
             Util::deleteDir($spaceBasePath . $spaceEntity['id']);
         }
     }
     UbirimiContainer::get()['repository']->get(Space::class)->deletePermissionsBySpaceId($spaceId);
     $query = "delete from documentator_space where id = ? limit 1";
     if ($stmt = UbirimiContainer::get()['db.connection']->prepare($query)) {
         $stmt->bind_param("i", $spaceId);
         $stmt->execute();
     }
     $spaceBasePath = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_DOCUMENTADOR, 'attachments');
     Util::deleteDir($spaceBasePath . $spaceId);
 }

 public static function manageModalAttachments($issueId, $loggedInUserId, $attachIdsToBeKept)
 {
     if (null != UbirimiContainer::get()['session']->has('added_attachments_in_screen')) {
         $attIdsSession = UbirimiContainer::get()['session']->get('added_attachments_in_screen');
         $uploadDirectory = Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId;
         for ($i = 0; $i < count($attIdsSession); $i++) {
             $attachmentId = $attIdsSession[$i];
             $attachment = UbirimiContainer::get()['repository']->get(IssueAttachment::class)->getById($attachmentId);
             if (!in_array($attachmentId, $attachIdsToBeKept)) {
                 // the attachment must be deleted
                 UbirimiContainer::get()['repository']->get(IssueAttachment::class)->deleteById($attachmentId);
                 if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $attachment['issue_id'] . '/' . $attachment['id'] . '/' . $attachment['name'])) {
                     unlink(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $attachment['issue_id'] . '/' . $attachment['id'] . '/' . $attachment['name']);
                     if (Util::isImage(Util::getExtension($attachment['name']))) {
                         if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $attachment['issue_id'] . '/' . $attachment['id'] . '/thumbs/' . $attachment['name'])) {
                             unlink(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $attachment['issue_id'] . '/' . $attachment['id'] . '/thumbs/' . $attachment['name']);
                             Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $attachment['issue_id'] . '/' . $attachment['id'] . '/thumbs');
                         }
                     }
                 }
                 if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $attachment['issue_id'] . '/' . $attachment['id'])) {
                     Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $attachment['issue_id'] . '/' . $attachment['id']);
                 }
                 // deal with the user_ folders
                 if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId . '/' . $attachment['id'] . '/' . $attachment['name'])) {
                     unlink(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId . '/' . $attachment['id'] . '/' . $attachment['name']);
                     if (Util::isImage(Util::getExtension($attachment['name']))) {
                         if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId . '/' . $attachment['id'] . '/thumbs/' . $attachment['name'])) {
                             unlink(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId . '/' . $attachment['id'] . '/thumbs/' . $attachment['name']);
                             Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId . '/' . $attachment['id'] . '/thumbs');
                         }
                     }
                 }
                 if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId . '/' . $attachment['id'])) {
                     Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId . '/' . $attachment['id']);
                 }
             } else {
                 if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId . '/' . $attachment['id'] . '/' . $attachment['name'])) {
                     if (!file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId)) {
                         // create the moder
                         mkdir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId);
                     }
                     // move the attachment
                     rename(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId . '/' . $attachment['id'], Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issueId . '/' . $attachment['id']);
                     // update the attachment
                     UbirimiContainer::get()['repository']->get(IssueAttachment::class)->updateByIdAndIssueId($attachmentId, $issueId);
                 }
             }
         }
         if (file_exists($uploadDirectory) && count(scandir($uploadDirectory)) == 2) {
             Util::deleteDir($uploadDirectory);
         }
         if (file_exists(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId)) {
             Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . 'user_' . $loggedInUserId);
         }
     }
 }

 public function deleteIssuesByProjectId($projectId)
 {
     $issues = UbirimiContainer::get()['repository']->get(Issue::class)->getByParameters(array('project' => $projectId));
     if ($issues) {
         while ($issue = $issues->fetch_array(MYSQLI_ASSOC)) {
             // delete issues from disk, if any
             Util::deleteDir(Util::getAssetsFolder(SystemProduct::SYS_PRODUCT_YONGO) . $issue['id']);
             UbirimiContainer::get()['repository']->get(Issue::class)->deleteById($issue['id']);
         }
     }
     $query = "DELETE IGNORE from yongo_issue WHERE project_id = " . $projectId;
     UbirimiContainer::get()['db.connection']->query($query);
 }