Exemplo n.º 1
0
 /**
  * @Route("/issue/edit/{id}/{project_id}", name="_editIssues")
  * @Template("TrackersBundle:Issues:edit.html.twig")
  */
 public function editAction($id, $project_id)
 {
     $issue = new Project_issues();
     $repositorys = $this->getDoctrine()->getRepository('TrackersBundle:Project_issues');
     if ($this->getRequest()->getMethod() == 'POST') {
         $requestData = $this->getRequest()->request;
         $form = $requestData->get('form');
         $assignedTo = $requestData->get('assigned_to');
         $date = $requestData->get('date');
         $time = $time = '0:0:0';
         // $requestData->get('time');
         $arr_date = explode('-', $date);
         $arr_time = explode(':', $time);
         $date_time = new \DateTime("now");
         $date_time->setDate($arr_date[0], $arr_date[1], $arr_date[2]);
         $date_time->setTime($arr_time[0], $arr_time[1], $arr_time[2]);
         $issue = $repositorys->find($id);
         $issue->setTitle($form['title']);
         $issue->setDescription($form['description']);
         $issue->setEndTime($date_time);
         $issue->setStatus($form['status']);
         $issue->setModified(new \DateTime("now"));
         $issue->setProjectId($project_id);
         $issue->setCreatedBy($this->getUser()->getId());
         $em = $this->getDoctrine()->getManager();
         $em->persist($issue);
         $em->flush();
         $repository_attachments = $this->getDoctrine()->getRepository('TrackersBundle:Project_issue_assignments');
         $attachments = $repository_attachments->findBy(array('issueId' => $issue->getId()));
         // delete user attachments
         if (!empty($attachments)) {
             foreach ($attachments as $attachment) {
                 $repository_attachments = $this->getDoctrine()->getRepository('TrackersBundle:Project_issue_assignments');
                 $em = $this->getDoctrine()->getManager();
                 $user_attachments = $repository_attachments->find($attachment->getId());
                 $em->remove($user_attachments);
                 $em->flush();
             }
         }
         $users_activity = new Users_activity();
         $users_activity->setUserId($this->getUser()->getId());
         $users_activity->setParentId($project_id);
         $users_activity->setItemId($issue->getId());
         $users_activity->setTypeId(5);
         $users_activity->setCreatedAt(new \DateTime("now"));
         $em->persist($users_activity);
         $em->flush();
         if (!empty($assignedTo)) {
             foreach ($assignedTo as $assigned) {
                 $project_issue_assignments = new Project_issue_assignments();
                 $project_issue_assignments->setUserId($assigned);
                 $project_issue_assignments->setIssueId($issue->getId());
                 $em->persist($project_issue_assignments);
                 $em->flush();
                 $repository = $this->getDoctrine()->getRepository('TrackersBundle:UserDetail');
                 $users = $repository->findBy(array('user_id' => $this->getUser()->getId()));
                 $user = $users[0];
                 $notifications = new Notifications();
                 $notifications->setUserId($assigned);
                 $notifications->setIssueId($issue->getId());
                 $notifications->setProjectId($project_id);
                 $notifications->setCreated(new \DateTime("now"));
                 $notifications->setIsRead(false);
                 $notifications->setText('You have reassign issue with title ' . $form['title'] . ' from ' . $user->getFirstname() . ' ' . $user->getLastname());
                 $em->persist($notifications);
                 $em->flush();
             }
         }
         $this->get('session')->getFlashBag()->add('notice', 'Issue is successfully edited!');
     }
     $em = $this->getDoctrine()->getEntityManager();
     $query = $em->createQuery("SELECT n.firstname , n.lastname ,n.user_id FROM TrackersBundle:UserDetail n, TrackersBundle:User_projects u WHERE  u.userId = n.user_id AND u.projectId = :project_id")->setParameter('project_id', $project_id);
     $entities = $query->getResult();
     $arr = array();
     $issues_id = $repositorys->find($id);
     // ---- load array mutil select
     $repository = $this->getDoctrine()->getRepository('TrackersBundle:Project_issue_assignments');
     $assignments = $repository->findBy(array('issueId' => $id));
     foreach ($entities as $post) {
         $is_select = false;
         foreach ($assignments as $assign) {
             if ($post['user_id'] == $assign->getUserId()) {
                 $is_select = true;
                 break;
             }
         }
         $arr[] = array('id' => $post['user_id'], 'fullName' => $post['firstname'] . " " . $post['lastname'], 'selected' => $is_select);
     }
     $assignedToOld = $issues_id->getassignedTo();
     // set form
     $issue->setTitle($issues_id->getTitle());
     $issue->setDescription($issues_id->getDescription());
     $issue->setStatus($issues_id->getStatus());
     $form = $this->createFormBuilder($issue)->add('title', 'text', array('label' => 'Tile', 'required' => true))->add('description', 'textarea', array('required' => false, 'label' => 'Description', 'attr' => array('class' => 'editor', 'id' => 'editor')))->add('status', 'choice', array('choices' => array('OPEN' => 'OPEN', 'HOLD' => 'HOLD', 'INPROGRESS' => 'INPROGRESS', 'CLOSED' => 'CLOSED', 'FINISHED' => 'FINISHED'), 'preferred_choices' => array($issues_id->getStatus()), 'label' => 'Status'))->getForm();
     return array('form' => $form->createView(), 'project_id' => $project_id, 'assignedTo' => $assignedToOld, 'assignedtos' => $arr, 'endtime' => $issues_id->getEndTime(), 'date' => $issues_id->getEndTime()->format('Y-m-d'), 'time' => $issues_id->getEndTime()->format('H:i:s'));
 }
Exemplo n.º 2
0
 /**
  * @Route("/ajaxAddTask", name="_ajaxAddTask")
  */
 public function ajaxAddTaskAction()
 {
     $arr = array();
     if ($this->getRequest()->getMethod() == 'POST') {
         $requestData = $this->getRequest()->request;
         $title = $requestData->get('title');
         $id_category = $requestData->get('id_category');
         $project_id = $requestData->get('project_id');
         $user_asign = $requestData->get('user_asign');
         $file_id = $requestData->get('file');
         $due_date = $requestData->get('due_date');
         $Project_task = new Project_task();
         $Project_task->setTitle($title);
         $Project_task->setDescription('');
         $Project_task->setCategoryTaskId($id_category);
         $Project_task->setProjectId($project_id);
         $Project_task->setStatus('OPEN');
         $Project_task->setCreatedBy($this->getUser()->getId());
         $Project_task->setCreated(new \DateTime('now'));
         //$Project_task->setModified(new \DateTime('now'));
         if ($due_date == '') {
             $due_start = '';
         } else {
             // date due time
             $arr_due_date = explode('-', $due_date);
             $due_start = new \DateTime();
             $due_start->setDate($arr_due_date[0], $arr_due_date[1], $arr_due_date[2]);
             $Project_task->setDuetime($due_start);
         }
         $em = $this->getDoctrine()->getManager();
         $em->persist($Project_task);
         $em->flush();
         $repository_user = $this->getDoctrine()->getRepository('TrackersBundle:UserDetail');
         $users = $repository_user->findBy(array('user_id' => $this->getUser()));
         $user = $users[0];
         $text = $user->getFirstname() . ' ' . $user->getLastname() . " is task with content " . $title;
         if (!empty($user_asign)) {
             foreach ($user_asign as $user_id) {
                 $userTask = new UserTask();
                 $userTask->setUserId($user_id);
                 $userTask->setTaskId($Project_task->getId());
                 $userTask->setCreated(new \DateTime('now'));
                 $em = $this->getDoctrine()->getManager();
                 $em->persist($userTask);
                 $em->flush();
                 // notifiaction user attachment
                 $notifications = new Notifications();
                 $notifications->setUserId($user_id);
                 $notifications->setTaskId($Project_task->getId());
                 $notifications->setProjectId($project_id);
                 $notifications->setCreated(new \DateTime("now"));
                 $notifications->setIsRead(false);
                 $notifications->setText($text);
                 $em->persist($notifications);
                 $em->flush();
             }
         }
         if (!empty($file_id)) {
             foreach ($file_id as $file) {
                 $repository = $this->getDoctrine()->getRepository('TrackersBundle:Project_Task_Attachments');
                 $files = $repository->find($file);
                 $files->setTaskId($Project_task->getId());
                 $em->persist($files);
                 $em->flush();
             }
         }
         $full_name = '';
         $em = $this->getDoctrine()->getEntityManager();
         $query = $em->createQuery("SELECT n.firstname , n.lastname , n.user_id   FROM TrackersBundle:UserDetail n  WHERE  n.user_id IN (:string)  ")->setParameter('string', $user_asign);
         $i = 1;
         foreach ($query->getResult() as $row) {
             $full_name .= $row['firstname'] . " " . $row['lastname'] . " ";
             if (count($query->getResult()) != $i) {
                 $full_name .= " - ";
             }
             $i++;
         }
         $arr = array('id' => $Project_task->getId(), 'title' => $Project_task->getTitle(), 'duetime' => $Project_task->getDuetime(), 'full_name' => $full_name, 'url' => $this->generateUrl('_showTask', array('task_id' => $Project_task->getId())));
     } else {
         die('Error...');
     }
     echo json_encode($arr);
     die;
 }
 /**
  * @Route("/savecomment", name="_savecomment")
  */
 public function saveCommentAction()
 {
     $requestData = $this->getRequest()->request;
     $comment = $requestData->get('comment');
     $issue_id = $requestData->get('issue_id');
     $project_id = $requestData->get('project_id');
     $file_id = $requestData->get('file_id');
     $projects_issues_comments = new Projects_issues_comments();
     $projects_issues_comments->setCreatedBy($this->getUser()->getId());
     $projects_issues_comments->setProjectId($project_id);
     $projects_issues_comments->setIssueId($issue_id);
     $projects_issues_comments->setComment($comment);
     $projects_issues_comments->setCreatedAt(new \DateTime("now"));
     $em = $this->getDoctrine()->getManager();
     $em->persist($projects_issues_comments);
     $em->flush();
     $users_activity = new Users_activity();
     $users_activity->setUserId($this->getUser()->getId());
     $users_activity->setParentId($project_id);
     $users_activity->setItemId($issue_id);
     $users_activity->setTypeId(2);
     $users_activity->setActionId($projects_issues_comments->getId());
     $users_activity->setCreatedAt(new \DateTime("now"));
     $em->persist($users_activity);
     $em->flush();
     if (!empty($file_id)) {
         foreach ($file_id as $file) {
             $repository = $this->getDoctrine()->getRepository('TrackersBundle:Projects_issues_attachments');
             $files = $repository->find($file);
             $files->setCommentId($projects_issues_comments->getId());
             $em->persist($files);
             $em->flush();
         }
     }
     $repository = $this->getDoctrine()->getRepository('TrackersBundle:UserDetail');
     $users = $repository->findBy(array('user_id' => $this->getUser()->getId()));
     $user = $users[0];
     $repository = $this->getDoctrine()->getRepository('TrackersBundle:Projects');
     $project = $repository->find($project_id);
     $repository = $this->getDoctrine()->getRepository('TrackersBundle:Project_issues');
     $issue = $repository->find($issue_id);
     // Get user detail
     $repository = $this->getDoctrine()->getRepository('TrackersBundle:UserDetail');
     $users = $repository->findBy(array('user_id' => $this->getUser()));
     $user = $users[0];
     $repository_attachments = $this->getDoctrine()->getRepository('TrackersBundle:Project_issue_assignments');
     $attachments = $repository_attachments->findBy(array('issueId' => $issue->getId()));
     // notifiaction user attachment
     $notifications = new Notifications();
     $text = $user->getFirstname() . ' ' . $user->getLastname() . " is comment issue with content " . $comment;
     // send user create project----
     if ($this->getUser()->getId() != $project->getOwnerId()) {
         $notifications = new Notifications();
         $notifications->setUserId($project->getOwnerId());
         $notifications->setIssueId($issue->getId());
         $notifications->setProjectId($project_id);
         $notifications->setCreated(new \DateTime("now"));
         $notifications->setIsRead(false);
         $notifications->setText($text);
         $em->persist($notifications);
         $em->flush();
     }
     // send user do issues----
     if (!empty($attachments)) {
         foreach ($attachments as $attachment) {
             if ($this->getUser()->getId() != $attachment->getUserId()) {
                 $notifications = new Notifications();
                 $notifications->setUserId($attachment->getUserId());
                 $notifications->setIssueId($issue->getId());
                 $notifications->setProjectId($project_id);
                 $notifications->setCreated(new \DateTime("now"));
                 $notifications->setIsRead(false);
                 $notifications->setText($text);
                 $em->persist($notifications);
                 $em->flush();
             }
         }
     }
     $repository = $this->getDoctrine()->getRepository('TrackersBundle:UserDetail');
     $users = $repository->findBy(array('user_id' => $this->getUser()->getId()));
     $user = $repository->find($users[0]->getId());
     $arr_comment = array('full_name' => $user->getFirstname() . " " . $user->getLastname(), 'created' => $projects_issues_comments->getCreatedAt(), 'comment' => $projects_issues_comments->getComment());
     echo json_encode($arr_comment);
     die;
 }