@GET
  @Path("/getAllPcuLabTestRequests")
  @Produces(MediaType.APPLICATION_JSON)
  public String getAllTestRequests() {

    List<PcuLabTestRequest> testRequestsList = requestDBDriver.getTestRequestsList();
    JSONSerializer serializer = new JSONSerializer();
    return serializer
        .include(
            "admintionID.admitionId",
            "ftest_ID.test_ID",
            "ftest_ID.test_IDName",
            "ftest_ID.test_Name",
            "admintionID.patientId.patientID",
            "admintionID.patientId.patientFullName",
            "fspecimen_ID.specimen_ID.*",
            "flab_ID.lab_ID.*",
            "flab_ID.lab_Name.*",
            "ftest_RequestPerson.userID.*",
            "ftest_RequestPerson.userName.*",
            "fsample_CenterID.sampleCenter_ID.*",
            "fsample_CenterID.sampleCenter_Name.*")
        .exclude(
            "*.class",
            "fspecimen_ID.*",
            "flab_ID.*",
            "ftest_RequestPerson.*",
            "fsample_CenterID.*",
            "admintionID.*",
            "ftest_ID.*",
            "ftest_RequestPerson.*")
        .transform(new DateTransformer("yyyy-MM-dd"), "test_RequestDate", "test_DueDate")
        .serialize(testRequestsList);
  }
  @POST
  @Path("/addPcuLabTestRequest")
  @Produces(MediaType.APPLICATION_JSON)
  @Consumes(MediaType.APPLICATION_JSON)
  public String addPcuLabTestRequest(JSONObject pJson) {

    try {

      PcuLabTestRequest request = new PcuLabTestRequest();

      int testID = pJson.getInt("ftest_ID");

      int labID = pJson.getInt("flab_ID");
      int admissionID = pJson.getInt("admintionID");
      int userid = pJson.getInt("ftest_RequestPerson");

      request.setComment(pJson.getString("comment").toString());
      request.setPriority(pJson.getString("priority").toString());
      request.setStatus(pJson.getString("status").toString());
      request.setTest_RequestDate(new Date());
      request.setTest_DueDate(new Date());

      requestDBDriver.addNewLabTestRequest(request, testID, admissionID, labID, userid);

      JSONSerializer jsonSerializer = new JSONSerializer();
      return jsonSerializer.include("pcu_lab_test_request_id").serialize(request);
    } catch (Exception e) {
      System.out.println(e.getMessage());

      return null;
    }
  }