@POST
@Path("/add")
public Response addUser(
@FormParam("name") String name,
@FormParam("email") String email,
@FormParam("phone") String phone,
@FormParam("organisation") String organisation,
@FormParam("startDate") String startDateString,
@FormParam("endDate") String endDateString,
@FormParam("numberOfPeople") int numberOfPeople,
@FormParam("catering") String catering,
@FormParam("additionalComments") String additionalComments) {
try {
logger.info("Begin processing customer add request");
Date startDate = Utils.formatDate(startDateString);
Date endDate = Utils.formatDate(endDateString);
Customer customer =
new Customer(
name,
email,
phone,
organisation,
startDate,
endDate,
numberOfPeople,
catering,
additionalComments);
logger.debug("Received Customer:" + customer);
dao.persist(customer);
Utils.sendMail(customer);
} catch (ParseException e) {
logger.info(
String.format(
"Received POST Request, but could not parse startDate:%s,endDate:%s",
startDateString, endDateString));
return Response.status(500).entity("Bad Request: Please enter a valid date format").build();
}
return Response.status(200)
.entity(
String.format(
"Thank you very much. Your booking enquiry for %s has been received. You will hear from us shortly.",
startDateString))
.build();
}
@GET
@Path("/getreport")
@Produces("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
public Response exportExcel(@QueryParam("from") String from, @QueryParam("to") String to)
throws Exception {
String params = from + to;
System.out.println(params);
File file = new File("src/main/resources/template.xlsx");
FileInputStream inputStream = new FileInputStream(file);
List<Customer> customerList = null;
XSSFWorkbook wb = new XSSFWorkbook(inputStream);
XSSFSheet sheet = wb.getSheetAt(0);
// CellStyle dateStyle = wb.createCellStyle();
// CreationHelper createHelper = wb.getCreationHelper();
// dateStyle.setDataFormat(createHelper.createDataFormat().getFormat(
// "yyyy/mm/dd hh:mm"));
if (from != null && to != null) {
Date startDate = Utils.formatDate(from);
Date endDate = Utils.formatDate(to);
customerList = dao.findByDate(startDate, endDate);
// wb = Utils.fillReport(wb, customerList);
} else {
customerList = dao.findAll();
// wb = Utils.fillReport(wb, customerList);
}
for (int i = 0; i < customerList.size(); i++) {
XSSFRow row = sheet.createRow(i + 3);
Customer customer = customerList.get(i);
for (int j = 0; j < 10; j++) {
XSSFCell cell = row.createCell(j);
switch (j) {
case 0:
cell.setCellValue(customer.getCreated());
cell.setCellStyle(sheet.getColumnStyle(j));
// cell.setCellStyle(dateStyle);
break;
case 1:
cell.setCellValue(customer.getName());
break;
case 2:
cell.setCellValue(customer.getEmail());
break;
case 3:
cell.setCellValue(customer.getPhone());
break;
case 4:
cell.setCellValue(customer.getOrganisation());
break;
case 5:
cell.setCellValue(customer.getStartDate());
cell.setCellStyle(sheet.getColumnStyle(j));
break;
case 6:
cell.setCellValue(customer.getEndDate());
cell.setCellStyle(sheet.getColumnStyle(j));
break;
case 7:
cell.setCellValue(customer.getNumberOfPeople());
break;
case 8:
cell.setCellValue(customer.isCatering());
break;
case 9:
cell.setCellValue(customer.getAdditionalComments());
break;
default:
break;
}
}
}
StreamingOutput stream =
new StreamingOutput() {
public void write(OutputStream output) throws IOException, WebApplicationException {
try {
wb.write(output);
wb.close();
} catch (Exception e) {
throw new WebApplicationException(e);
}
}
};
Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("YYYY_MM_dd");
String dateString = sdf.format(date);
return Response.ok(stream)
.header(
"content-disposition",
"attachment; filename = space-bookings-export_" + dateString + ".xlsx")
.build();
}
@GET
@Path("/getcount")
public int getAll() {
return dao.findAll().size();
}
/** Root resource (exposed at "myresource" path) */
@Path("api")
public class CustomerManagerResource {
static final Logger logger = LogManager.getLogger();
static final CustomerDaoImpl dao = CustomerDaoImpl.getInstance();
/**
* Method handling HTTP GET requests. The returned object will be sent to the client as
* "text/plain" media type.
*
* @return String that will be returned as a text/plain response.
*/
@GET
@Produces(MediaType.TEXT_PLAIN)
public String getIt() {
return "Hello, Jersey-Rest-Heroku (space)!";
}
@GET
@Path("/db")
public String getDbInfo() {
String DATABASE_URL = System.getenv("DATABASE_URL");
URI dbUri = null;
if (DATABASE_URL != null && !DATABASE_URL.equals("")) {
try {
dbUri = new URI(DATABASE_URL);
} catch (URISyntaxException e) {
logger.info("Could not read DATABASE_URL heroku environment variable");
e.printStackTrace();
}
}
return "hibernate.connection.url:"
+ "jdbc:postgresql://"
+ dbUri.getHost()
+ ":"
+ dbUri.getPort()
+ "/"
+ dbUri.getPath();
}
@GET
@Path("/getcount")
public int getAll() {
return dao.findAll().size();
}
@GET
@Path("/getreport")
@Produces("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
public Response exportExcel(@QueryParam("from") String from, @QueryParam("to") String to)
throws Exception {
String params = from + to;
System.out.println(params);
File file = new File("src/main/resources/template.xlsx");
FileInputStream inputStream = new FileInputStream(file);
List<Customer> customerList = null;
XSSFWorkbook wb = new XSSFWorkbook(inputStream);
XSSFSheet sheet = wb.getSheetAt(0);
// CellStyle dateStyle = wb.createCellStyle();
// CreationHelper createHelper = wb.getCreationHelper();
// dateStyle.setDataFormat(createHelper.createDataFormat().getFormat(
// "yyyy/mm/dd hh:mm"));
if (from != null && to != null) {
Date startDate = Utils.formatDate(from);
Date endDate = Utils.formatDate(to);
customerList = dao.findByDate(startDate, endDate);
// wb = Utils.fillReport(wb, customerList);
} else {
customerList = dao.findAll();
// wb = Utils.fillReport(wb, customerList);
}
for (int i = 0; i < customerList.size(); i++) {
XSSFRow row = sheet.createRow(i + 3);
Customer customer = customerList.get(i);
for (int j = 0; j < 10; j++) {
XSSFCell cell = row.createCell(j);
switch (j) {
case 0:
cell.setCellValue(customer.getCreated());
cell.setCellStyle(sheet.getColumnStyle(j));
// cell.setCellStyle(dateStyle);
break;
case 1:
cell.setCellValue(customer.getName());
break;
case 2:
cell.setCellValue(customer.getEmail());
break;
case 3:
cell.setCellValue(customer.getPhone());
break;
case 4:
cell.setCellValue(customer.getOrganisation());
break;
case 5:
cell.setCellValue(customer.getStartDate());
cell.setCellStyle(sheet.getColumnStyle(j));
break;
case 6:
cell.setCellValue(customer.getEndDate());
cell.setCellStyle(sheet.getColumnStyle(j));
break;
case 7:
cell.setCellValue(customer.getNumberOfPeople());
break;
case 8:
cell.setCellValue(customer.isCatering());
break;
case 9:
cell.setCellValue(customer.getAdditionalComments());
break;
default:
break;
}
}
}
StreamingOutput stream =
new StreamingOutput() {
public void write(OutputStream output) throws IOException, WebApplicationException {
try {
wb.write(output);
wb.close();
} catch (Exception e) {
throw new WebApplicationException(e);
}
}
};
Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("YYYY_MM_dd");
String dateString = sdf.format(date);
return Response.ok(stream)
.header(
"content-disposition",
"attachment; filename = space-bookings-export_" + dateString + ".xlsx")
.build();
}
@POST
@Path("/add")
public Response addUser(
@FormParam("name") String name,
@FormParam("email") String email,
@FormParam("phone") String phone,
@FormParam("organisation") String organisation,
@FormParam("startDate") String startDateString,
@FormParam("endDate") String endDateString,
@FormParam("numberOfPeople") int numberOfPeople,
@FormParam("catering") String catering,
@FormParam("additionalComments") String additionalComments) {
try {
logger.info("Begin processing customer add request");
Date startDate = Utils.formatDate(startDateString);
Date endDate = Utils.formatDate(endDateString);
Customer customer =
new Customer(
name,
email,
phone,
organisation,
startDate,
endDate,
numberOfPeople,
catering,
additionalComments);
logger.debug("Received Customer:" + customer);
dao.persist(customer);
Utils.sendMail(customer);
} catch (ParseException e) {
logger.info(
String.format(
"Received POST Request, but could not parse startDate:%s,endDate:%s",
startDateString, endDateString));
return Response.status(500).entity("Bad Request: Please enter a valid date format").build();
}
return Response.status(200)
.entity(
String.format(
"Thank you very much. Your booking enquiry for %s has been received. You will hear from us shortly.",
startDateString))
.build();
}
// @GET
// @Path("/getreport")
// @Produces("text/plain")
// public Response getReport() throws IOException {
// Date date = new Date();
// SimpleDateFormat sdf = new SimpleDateFormat("YYYY_MM_dd");
// String dateString = sdf.format(date);
// // File file = new File("foo.txt");
// // FileOutputStream out = new FileOutputStream(file);
// // byte[] data = {1, 2, 3, 4, 5};
// // out.write(data);
// // out.close();
// PrintWriter writer = new PrintWriter("foo.txt", "UTF-8");
// writer.println("The first line");
// writer.println("The second line");
// writer.close();
// File file = new File("foo.txt");
//
// ResponseBuilder response = Response.ok((Object) file);
// response.header("Content-Disposition",
// "attachment; filename=\"space_report_"+dateString+".txt\"");
// return response.build();
//
// }
}
