Skip to content

Commit

Permalink
WORK ON DOCUMENT CONTROLLER
Browse files Browse the repository at this point in the history 
CREATE NOMENCLATURE CONTROLLER
TODO:
DOCUMENT MANIPULATION
DOCUMENT FILE MANIPULATION
TASK MANIPULATION
SHOW CONTEOLLED TASK FOR USER
SHOW USERS TASK
STOREHAUSE MANIPULATION
GOOD PRODUCTION AND SERVICE
REGISTER BED PRODUCT
  • Loading branch information
@FairWindCo
FairWindCo committed Oct 20, 2015
1 parent 1ca0101 commit 42b8093
Show file tree
Hide file tree
Showing 15 changed files with 1,769 additions and 134 deletions.
258 changes: 250 additions & 8 deletions src/main/java/ua/pp/fairwind/favorid/internalDB/controllers/DocumentController.java
View file
Original file line number Diff line number Diff line change
@@ -1,6 +1,7 @@
package ua.pp.fairwind.favorid.internalDB.controllers;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.propertyeditors.CustomDateEditor;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Sort;
Expand All @@ -10,27 +11,31 @@
import org.springframework.transaction.annotation.Transactional;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.WebDataBinder;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import ua.pp.fairwind.favorid.internalDB.jgrid.JGridRowsResponse;
import ua.pp.fairwind.favorid.internalDB.jgrid.JSComboExpenseResp;
import ua.pp.fairwind.favorid.internalDB.jgrid.Utils;
import ua.pp.fairwind.favorid.internalDB.model.Counterparty;
import ua.pp.fairwind.favorid.internalDB.model.Person;
import ua.pp.fairwind.favorid.internalDB.model.administrative.User;
import ua.pp.fairwind.favorid.internalDB.model.directories.DocumentType;
import ua.pp.fairwind.favorid.internalDB.model.document.Document;
import ua.pp.fairwind.favorid.internalDB.model.document.DocumentFile;
import ua.pp.fairwind.favorid.internalDB.model.document.DocumentSecurity;
import ua.pp.fairwind.favorid.internalDB.model.document.DocumentSubscribe;
import ua.pp.fairwind.favorid.internalDB.model.proxy.DocumentProxy;
import ua.pp.fairwind.favorid.internalDB.repository.CounterpartyRepository;
import ua.pp.fairwind.favorid.internalDB.repository.DocumentRepository;
import ua.pp.fairwind.favorid.internalDB.repository.DocumentTypeRepository;
import ua.pp.fairwind.favorid.internalDB.repository.PersonRepository;
import ua.pp.fairwind.favorid.internalDB.repository.*;
import ua.pp.fairwind.favorid.internalDB.security.UserDetailsAdapter;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

/**
Expand All @@ -47,6 +52,12 @@ public class DocumentController {
PersonRepository personRepository;
@Autowired
CounterpartyRepository counterpartyRepository;
@Autowired
DocumentSecurityRepository documentSecurityRepository;
@Autowired
DocumentSubscribeRepository documentSubscribeRepository;
@Autowired
DocumentFileRepository documentFileRepository;


@Secured("ROLE_USER")
Expand Down Expand Up @@ -91,6 +102,132 @@ public JGridRowsResponse<Document> getTable(HttpServletRequest request){
}
}

@Transactional(readOnly = true)
@RequestMapping(value = "/security_listing", method = RequestMethod.POST)
@ResponseBody
public JGridRowsResponse<DocumentSecurity> getSecurityTable(HttpServletRequest request,HttpServletResponse response,@RequestParam Long document_id){
PageRequest pageRequest=null;
if(request.getParameter("page")!=null){
int rows=10;
int page;
try {
page = Integer.parseInt(request.getParameter("page")) - 1;
rows = request.getParameter("rows") == null ? 10 : Integer.parseInt(request.getParameter("rows"));
if(request.getParameter("sidx")!=null && !request.getParameter("sidx").isEmpty()){
String direction=request.getParameter("sord");
pageRequest=new PageRequest(page,rows,"asc".equals(direction)? Sort.Direction.ASC: Sort.Direction.DESC,request.getParameter("sidx"));
} else {
pageRequest=new PageRequest(page,rows);
}
}catch (NumberFormatException ex){
//do nothing
}

}/**/
Document document=documentRepository.findOne(document_id);
if(document!=null) {
String filterName = request.getParameter("surname");
if (pageRequest != null) {
if (filterName != null && !filterName.isEmpty()) {
return new JGridRowsResponse<>(documentSecurityRepository.findByDocumentAndPersonSurname(document,filterName, pageRequest));
} else
return new JGridRowsResponse<>(documentSecurityRepository.findByDocument(document,pageRequest));
} else {
if (filterName != null && !filterName.isEmpty()) {
return new JGridRowsResponse<>(documentSecurityRepository.findByDocumentAndPersonSurname(document,filterName));
} else
return new JGridRowsResponse<>(documentSecurityRepository.findByDocument(document));
}
} else {
response.setStatus(404);
return null;
}
}

@Transactional(readOnly = true)
@RequestMapping(value = "/subscriber_listing", method = RequestMethod.POST)
@ResponseBody
public JGridRowsResponse<DocumentSubscribe> getSubscriberTable(HttpServletRequest request,HttpServletResponse response,@RequestParam Long document_id){
PageRequest pageRequest=null;
if(request.getParameter("page")!=null){
int rows=10;
int page;
try {
page = Integer.parseInt(request.getParameter("page")) - 1;
rows = request.getParameter("rows") == null ? 10 : Integer.parseInt(request.getParameter("rows"));
if(request.getParameter("sidx")!=null && !request.getParameter("sidx").isEmpty()){
String direction=request.getParameter("sord");
pageRequest=new PageRequest(page,rows,"asc".equals(direction)? Sort.Direction.ASC: Sort.Direction.DESC,request.getParameter("sidx"));
} else {
pageRequest=new PageRequest(page,rows);
}
}catch (NumberFormatException ex){
//do nothing
}

}/**/
Document document=documentRepository.findOne(document_id);
if(document!=null) {
String filterName = request.getParameter("surname");
if (pageRequest != null) {
if (filterName != null && !filterName.isEmpty()) {
return new JGridRowsResponse<>(documentSubscribeRepository.findByDocumentAndPersonSurname(document,filterName, pageRequest));
} else
return new JGridRowsResponse<>(documentSubscribeRepository.findByDocument(document,pageRequest));
} else {
if (filterName != null && !filterName.isEmpty()) {
return new JGridRowsResponse<>(documentSubscribeRepository.findByDocumentAndPersonSurname(document,filterName));
} else
return new JGridRowsResponse<>(documentSubscribeRepository.findByDocument(document));
}
} else {
response.setStatus(404);
return null;
}
}

@Transactional(readOnly = true)
@RequestMapping(value = "/file_listing", method = RequestMethod.POST)
@ResponseBody
public JGridRowsResponse<DocumentFile> getFiles(HttpServletRequest request,HttpServletResponse response,@RequestParam Long document_id){
PageRequest pageRequest=null;
if(request.getParameter("page")!=null){
int rows=10;
int page;
try {
page = Integer.parseInt(request.getParameter("page")) - 1;
rows = request.getParameter("rows") == null ? 10 : Integer.parseInt(request.getParameter("rows"));
if(request.getParameter("sidx")!=null && !request.getParameter("sidx").isEmpty()){
String direction=request.getParameter("sord");
pageRequest=new PageRequest(page,rows,"asc".equals(direction)? Sort.Direction.ASC: Sort.Direction.DESC,request.getParameter("sidx"));
} else {
pageRequest=new PageRequest(page,rows);
}
}catch (NumberFormatException ex){
//do nothing
}

}/**/
Document document=documentRepository.findOne(document_id);
if(document!=null) {
String filterName = request.getParameter("fileName");
if (pageRequest != null) {
if (filterName != null && !filterName.isEmpty()) {
return new JGridRowsResponse<>(documentFileRepository.findByDocumentAndFileName(document, filterName, pageRequest));
} else
return new JGridRowsResponse<>(documentFileRepository.findByDocument(document,pageRequest));
} else {
if (filterName != null && !filterName.isEmpty()) {
return new JGridRowsResponse<>(documentFileRepository.findByDocumentAndFileName(document, filterName));
} else
return new JGridRowsResponse<>(documentFileRepository.findByDocument(document));
}
} else {
response.setStatus(404);
return null;
}
}

@Transactional(readOnly = false)
@RequestMapping(value = "/edit", method = {RequestMethod.POST,RequestMethod.GET})
public void editor(@RequestParam String oper,Document document,BindingResult result,HttpServletRequest request,HttpServletResponse response)throws IOException {
Expand Down Expand Up @@ -196,6 +333,101 @@ public void editor(@RequestParam String oper,Document document,BindingResult res
}
}

@Transactional(readOnly = false)
@RequestMapping(value = "/editafile", method = {RequestMethod.POST,RequestMethod.GET})
public void fileEditor(@RequestParam String oper,@RequestParam Long document_id,@RequestParam Long id,@RequestParam MultipartFile file,HttpServletResponse response)throws IOException {
UserDetailsAdapter userDetail=(UserDetailsAdapter)SecurityContextHolder.getContext().getAuthentication().getPrincipal();
if(userDetail==null){
response.sendError(403, "FORBIDDEN!");
return;
}
Document document=documentRepository.findOne(document_id);
User creator=document.getCreationUser();
if(document==null) {
response.sendError(404, "NOT FOUND DOCUMENT ID:"+document_id);
return;
}
switch (oper){
case "add":
if(file==null){
response.sendError(400, "BAD REQUEST! NO FILE SEND!");
}
if(userDetail.hasRole("ROLE_ADD_DOCUMENTS")||(creator!=null && creator.equals(userDetail.getUserP()))) {
DocumentFile fileInfo=new DocumentFile();
fileInfo.setFileName(file.getName());
fileInfo.setMimeType(file.getContentType());
fileInfo.setSize(file.getSize());
fileInfo.setDocument(document);
String path="e:/"+(document.getDocumentType()!=null?document.getDocumentType().getName()+"/":"")+file.getName();
fileInfo.setFilePath(path);
try(FileOutputStream stream=new FileOutputStream(path)) {
stream.write(file.getBytes());
stream.flush();
}catch (IOException io){
response.sendError(406, "ERROR: "+io.getLocalizedMessage());
return;
}
documentFileRepository.save(fileInfo);
documentRepository.save(document);
response.setStatus(200);
} else {
response.sendError(403, "FORBIDDEN!");
}
break;
case "edit":
if(userDetail.hasRole("ROLE_EDIT_DOCUMENTS")||(creator!=null && creator.equals(userDetail.getUserP()))) {
DocumentFile oldFileInfo=documentFileRepository.findOne(id);
if(oldFileInfo!=null) {
File oldFile=new File(oldFileInfo.getFilePath());
oldFileInfo.setDocument(null);
documentFileRepository.delete(oldFileInfo);
response.setStatus(200);
} else {
response.sendError(404, "NOT FOUND FILE ID:"+id);
return;
}
DocumentFile fileInfo=new DocumentFile();
fileInfo.setFileName(file.getName());
fileInfo.setMimeType(file.getContentType());
fileInfo.setSize(file.getSize());
fileInfo.setDocument(document);
String path="e:/"+(document.getDocumentType()!=null?document.getDocumentType().getName()+"/":"")+file.getName();
fileInfo.setFilePath(path);
try(FileOutputStream stream=new FileOutputStream(path)) {
stream.write(file.getBytes());
stream.flush();
}catch (IOException io){
response.sendError(406, "ERROR: "+io.getLocalizedMessage());
return;
}
documentFileRepository.save(fileInfo);
documentRepository.save(document);
response.setStatus(200);
} else {
response.sendError(403, "FORBIDDEN!");
}
break;
case "del":
if(userDetail.hasRole("ROLE_DELETE_DOCUMENTS")||(creator!=null && creator.equals(userDetail.getUserP()))) {
DocumentFile fileInfo=documentFileRepository.findOne(id);
if(fileInfo!=null) {
fileInfo.setDocument(null);
File oldFile=new File(fileInfo.getFilePath());
oldFile.delete();
documentFileRepository.delete(fileInfo);
response.setStatus(200);
} else {
response.sendError(404, "NOT FOUND FILE ID:"+id);
}
} else {
response.sendError(403, "FORBIDDEN!");
}
break;
default:
response.sendError(406,"UNKNOWN OPERATION");
}
}

@Transactional(readOnly = true)
@RequestMapping(value = "/showList", method = RequestMethod.GET)
@ResponseBody
Expand Down Expand Up @@ -234,4 +466,14 @@ public Object simpleClientList(@RequestParam(required = false) Integer page_num,
}
}
}

@InitBinder
private void dateBinder(WebDataBinder binder) {
//The date format to parse or output your dates
SimpleDateFormat dateFormat = new SimpleDateFormat("dd-MM-yyyy");
//Create a new CustomDateEditor
CustomDateEditor editor = new CustomDateEditor(dateFormat, true);
//Register it as custom editor for the Date type
binder.registerCustomEditor(Date.class, editor);
}
}
19 changes: 19 additions & 0 deletions src/main/java/ua/pp/fairwind/favorid/internalDB/model/administrative/User.java
View file
Original file line number Diff line number Diff line change
Expand Up @@ -101,4 +101,23 @@ public long getVersionId() {
public void setVersionId(long versionId) {
this.versionId = versionId;
}

@Override
public boolean equals(Object o) {
if (this == o) return true;
if (o == null || getClass() != o.getClass()) return false;

User user = (User) o;

if (versionId != user.versionId) return false;
return !(userID != null ? !userID.equals(user.userID) : user.userID != null);

}

@Override
public int hashCode() {
int result = userID != null ? userID.hashCode() : 0;
result = 31 * result + (int) (versionId ^ (versionId >>> 32));
return result;
}
}
11 changes: 8 additions & 3 deletions src/main/java/ua/pp/fairwind/favorid/internalDB/model/document/Document.java
View file
Original file line number Diff line number Diff line change
@@ -1,5 +1,6 @@
package ua.pp.fairwind.favorid.internalDB.model.document;

import com.fasterxml.jackson.annotation.JsonIgnore;
import com.fasterxml.jackson.annotation.JsonManagedReference;
import org.springframework.data.annotation.CreatedBy;
import org.springframework.data.annotation.LastModifiedBy;
Expand Down Expand Up @@ -59,18 +60,22 @@ public class Document {
Document parent;

@OneToMany
@JsonManagedReference
@JsonIgnore
final Set<Document> atachments=new HashSet<>();

@OneToMany(mappedBy = "document")
@JsonManagedReference
@JsonIgnore
final Set<DocumentFile> documentFiles=new HashSet<>();

DOCUMENT_SECURITY_MODEL security_model;
@OneToMany(mappedBy = "document")
@JsonManagedReference
@JsonIgnore
final Set<DocumentSecurity> securities=new HashSet<>();

@OneToMany(mappedBy = "document")
@JsonIgnore
final Set<DocumentSubscribe> subscribes=new HashSet<>();

Date creationDate=new Date();
@LastModifiedDate
Date modificationDate;
Expand Down
8 changes: 7 additions & 1 deletion src/main/java/ua/pp/fairwind/favorid/internalDB/model/document/DocumentFile.java
View file
Original file line number Diff line number Diff line change
Expand Up @@ -77,6 +77,12 @@ public Document getDocument() {
}

public void setDocument(Document document) {
this.document = document;
if(this.document!=null){
this.document.documentFiles.remove(this);
}
if(document!=null) {
this.document = document;
this.document.documentFiles.add(this);
}
}
}
Loading

0 comments on commit 42b8093

Please sign in to comment.