GetRequisitionDetailsAPI.java example

Explorer
elmis-master
- modules
- test-modules
/*
 * This program is part of the OpenLMIS logistics management information system platform software.
 * Copyright © 2013 VillageReach
 *
 * This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
 *  
 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more details.
 * You should have received a copy of the GNU Affero General Public License along with this program.  If not, see http://www.gnu.org/licenses.  For additional information contact info@OpenLMIS.org. 
 */

package org.openlmis.functional;

import org.apache.commons.lang3.StringUtils;
import org.openlmis.UiUtils.HttpClient;
import org.openlmis.UiUtils.ResponseEntity;
import org.openlmis.pod.domain.OrderPOD;
import org.testng.annotations.AfterMethod;
import org.testng.annotations.BeforeMethod;
import org.testng.annotations.Test;

import java.io.IOException;
import java.sql.SQLException;

import static com.thoughtworks.selenium.SeleneseTestBase.*;
import static java.lang.String.format;

public class GetRequisitionDetailsAPI extends JsonUtility {

  public static final String FULL_JSON_POD_TXT_FILE_NAME = "ReportJsonPOD.txt";
  public static final String URL = "http://localhost:9091/rest-api/requisitions/";

  @BeforeMethod(groups = {"webservice", "webserviceSmoke"})
  public void setUp() throws InterruptedException, SQLException, IOException {
    super.setup();
    super.setupTestData(false);
    super.setupDataRequisitionApprove();
    createVirtualFacilityThroughApi("V10", "F10");
    dbWrapper.insertProcessingPeriod("current", "current period", "2013-01-30", "2016-01-30", 1, "M");
    dbWrapper.insertRoleAssignmentForSupervisoryNodeForProgramId("commTrack", "store in-charge", "N1");
    dbWrapper.setupOrderNumberConfiguration("O", true, true, true, true);
    dbWrapper.updateRestrictLogin("commTrack", true);
  }

  @AfterMethod(groups = {"webservice", "webserviceSmoke"})
  public void tearDown() throws SQLException {
    dbWrapper.deleteData();
    dbWrapper.closeConnection();
  }

  @Test(groups = {"webserviceSmoke"})
  public void testGetRequisitionDetails() throws SQLException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    dbWrapper.updateRequisitionStatus("AUTHORIZED", "commTrack", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();
    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("AUTHORIZED", responseEntity);
    checkOrderDetailsNotPresent(responseEntity);
    assertEquals(StringUtils.countMatches(responseEntity.getResponse(), ":"), 20);
  }

  @Test(groups = {"webserviceSmoke"})
  public void testGetRequisitionDetailsWithMultipleProducts() throws SQLException, IOException {
    dbWrapper.updateFieldValue("products", "fullSupply", "true", "code", "P11");

    long id = submitRnRThroughApi("V10", "HIV", "P10", 1, 10, 1, 0, 0, 2);
    HttpClient client = new HttpClient();
    client.createContext();

    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"productCode\":\"P11\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"skipped\":true"));
    dbWrapper.updateFieldValue("products", "fullSupply", "false", "code", "P11");
  }

  @Test(groups = {"webservice"})
  public void testGetRequisitionDetailsWithInvalidRequisitionID() {
    HttpClient client = new HttpClient();
    client.createContext();

    ResponseEntity responseEntity = client.SendJSON("", URL + 100, "GET", "commTrack", "Admin123");
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"programCode\":\"HIV\""));
    assertTrue("Response entity : " + responseEntity.getResponse(),
      responseEntity.getResponse().contains("\"error\":\"Requisition Not Found\""));
    assertEquals(400, responseEntity.getStatus());

    responseEntity = client.SendJSON("", URL + "@", "GET", "commTrack", "Admin123");
    assertFalse("Response entity : " + responseEntity.getResponse(),
      responseEntity.getResponse().contains("\"programCode\":\"HIV\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"error\":\"Oops, something has gone wrong. Please try again later\""));
    assertEquals(500, responseEntity.getStatus());
  }

  @Test(groups = {"webservice"})
  public void testGetRequisitionDetailsWithInvalidPassword() throws SQLException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();

    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin");
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"programCode\":\"HIV\""));
    assertTrue("Response entity : " + responseEntity.getResponse(),
      responseEntity.getResponse().contains("Authentication Failed"));
    assertEquals(401, responseEntity.getStatus());
  }

  @Test(groups = {"webservice"})
  public void testGetRequisitionDetailsWithInvalidUser() throws SQLException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();

    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "comm", "Admin123");
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"programCode\":\"HIV\""));
    assertTrue("Response entity : " + responseEntity.getResponse(),
      responseEntity.getResponse().contains("Authentication Failed"));
    assertEquals(401, responseEntity.getStatus());
  }

  @Test(groups = {"webservice"})
  public void testGetRequisitionDetailsWithBlankRequisitionID() {
    HttpClient client = new HttpClient();
    client.createContext();

    ResponseEntity responseEntity = client.SendJSON("", URL, "GET", "commTrack", "Admin123");
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"programCode\":\"HIV\""));
    assertTrue("Response entity : " + responseEntity.getResponse(),
      responseEntity.getResponse().contains("Request method 'GET' not supported"));
    assertEquals(405, responseEntity.getStatus());
  }

  @Test(groups = {"webservice"})
  public void testGetRequisitionDetailsWithMalformedRequest() throws SQLException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();

    ResponseEntity responseEntity = client.SendJSON("", "http://localhost:9091/rest-api/requisition/" + id, "GET",
      "commTrack", "Admin123");
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"programCode\":\"HIV\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("NOT_FOUND"));
    assertEquals(404, responseEntity.getStatus());
  }

  @Test(groups = {"webservice"})
  public void testGetRequisitionDetailsWithUnrecognizedField() throws SQLException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();

    ResponseEntity responseEntity = client.SendJSON("", URL + id + "/programCode", "GET", "commTrack", "Admin123");
    assertFalse("Response entity : " + responseEntity.getResponse(),
      responseEntity.getResponse().contains("\"programCode\":\"HIV\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("NOT_FOUND"));
    assertEquals(404, responseEntity.getStatus());
  }

  @Test(groups = {"webservice"})
  public void testGetRequisitionDetailsWithSpaceBeforeRequisitionID() throws SQLException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    dbWrapper.updateRequisitionStatus("AUTHORIZED", "commTrack", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();
    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("AUTHORIZED", responseEntity);
    checkOrderDetailsNotPresent(responseEntity);
  }

  @Test(groups = {"webservice"})
  public void testGetRequisitionDetailsWithNullRemarks() throws SQLException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    dbWrapper.updateRequisitionStatus("AUTHORIZED", "commTrack", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();

    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"programCode\":\"HIV\""));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("remarks:"));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"orderStatus\":"));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"supplyingFacilityCode\""));
    assertEquals(200, responseEntity.getStatus());
  }

  @Test(groups = {"webservice"})
  public void testRequisitionDetailsAfterApprovalForExportOrdersFlagSetFalse() throws SQLException, IOException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    dbWrapper.updateRequisitionStatus("AUTHORIZED", "commTrack", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();
    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("AUTHORIZED", responseEntity);
    checkOrderDetailsNotPresent(responseEntity);

    dbWrapper.setExportOrdersFlagInSupplyLinesTable(false, "F10");
    dbWrapper.updateFieldValue("facilities", "virtualFacility", "true", "code", "F10");
    dbWrapper.setupUserForFulfillmentRole("commTrack", "store in-charge", "F10");
    dbWrapper.updateRestrictLogin("commTrack", false);
    approveRequisition(id, 65);
    convertToOrder("commTrack", "Admin123");
    dbWrapper.updateRestrictLogin("commTrack", true);
    responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("RELEASED", responseEntity);
    checkOrderStatus(65, "READY_TO_PACK", responseEntity);
  }

  @Test(groups = {"webservice"})
  public void testRequisitionDetailsAfterApprovalForExportOrdersFlagSetTrue() throws SQLException, IOException, InterruptedException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    dbWrapper.updateRequisitionStatus("AUTHORIZED", "commTrack", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();
    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("AUTHORIZED", responseEntity);
    checkOrderDetailsNotPresent(responseEntity);

    dbWrapper.setExportOrdersFlagInSupplyLinesTable(true, "F10");
    dbWrapper.updateFieldValue("facilities", "virtualFacility", "true", "code", "F10");
    dbWrapper.setupUserForFulfillmentRole("commTrack", "store in-charge", "F10");
    approveRequisition(id, 65);
    dbWrapper.updateRestrictLogin("commTrack", false);
    convertToOrder("commTrack", "Admin123");
    dbWrapper.updateRestrictLogin("commTrack", true);
    responseEntity = waitUntilOrderStatusUpdatedOrTimeOut(id, "\"orderStatus\":\"RELEASED\"");
    checkRequisitionStatus("RELEASED", responseEntity);
    checkOrderStatus(65, "TRANSFER_FAILED", responseEntity);
  }

  @Test(groups = {"webservice"})
  public void testRequisitionDetailsAfterApprovalForExportOrdersFlagSetTrueAndFtpDetailsValid() throws SQLException, IOException, InterruptedException {
    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    dbWrapper.updateRequisitionStatus("AUTHORIZED", "commTrack", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();

    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("AUTHORIZED", responseEntity);
    checkOrderDetailsNotPresent(responseEntity);

    dbWrapper.setExportOrdersFlagInSupplyLinesTable(true, "F10");
    dbWrapper.enterValidDetailsInFacilityFtpDetailsTable("F10");
    dbWrapper.updateFieldValue("facilities", "virtualFacility", "true", "code", "F10");
    dbWrapper.setupUserForFulfillmentRole("commTrack", "store in-charge", "F10");

    approveRequisition(id, 65);
    dbWrapper.updateRestrictLogin("commTrack", false);
    convertToOrder("commTrack", "Admin123");
    dbWrapper.updateRestrictLogin("commTrack", true);

    responseEntity = waitUntilOrderStatusUpdatedOrTimeOut(id, "\"orderStatus\":\"RELEASED\"");
    checkRequisitionStatus("RELEASED", responseEntity);
    checkOrderStatus(65, "RELEASED", responseEntity);
  }

  @Test(groups = {"webservice"})
  public void testRequisitionDetailsAfterOrderIsCreated() throws SQLException, IOException {

    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    dbWrapper.updateRequisitionStatus("AUTHORIZED", "commTrack", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();
    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("AUTHORIZED", responseEntity);
    checkOrderDetailsNotPresent(responseEntity);

    dbWrapper.updateFieldValue("facilities", "virtualFacility", "true", "code", "F10");
    dbWrapper.setupUserForFulfillmentRole("commTrack", "store in-charge", "F10");

    approveRequisition(id, 65);
    dbWrapper.updateRestrictLogin("commTrack", false);
    convertToOrder("commTrack", "Admin123");
    dbWrapper.updateRestrictLogin("commTrack", true);
    responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("RELEASED", responseEntity);
    checkOrderStatus(65, "READY_TO_PACK", responseEntity);

    dbWrapper.assignRight("store in-charge", "MANAGE_POD");

    OrderPOD OrderPODFromJson = JsonUtility.readObjectFromFile(FULL_JSON_POD_TXT_FILE_NAME, OrderPOD.class);
    OrderPODFromJson.getPodLineItems().get(0).setQuantityReceived(65);
    OrderPODFromJson.getPodLineItems().get(0).setProductCode("P10");

    String orderId = generateOrderNumberForIdAndDefaultConfiguration(id, "HIV");

    dbWrapper.setupOrderNumberConfiguration("P", true, true, true, true);
    checkOrderNumber(orderId, responseEntity);
  }

  @Test(groups = {"webservice"})
  public void testRequisitionDetailsAfterPOD() throws SQLException, IOException {

    HttpClient client = new HttpClient();
    client.createContext();
    submitRequisition("commTrack1", "HIV");
    dbWrapper.updateRequisitionStatus("AUTHORIZED", "commTrack", "HIV");
    Long id = (long) dbWrapper.getMaxRnrID();
    ResponseEntity responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("AUTHORIZED", responseEntity);
    checkOrderDetailsNotPresent(responseEntity);

    dbWrapper.updateFieldValue("facilities", "virtualFacility", "true", "code", "F10");
    dbWrapper.setupUserForFulfillmentRole("commTrack", "store in-charge", "F10");

    approveRequisition(id, 65);
    dbWrapper.updateRestrictLogin("commTrack", false);
    convertToOrder("commTrack", "Admin123");
    dbWrapper.updateRestrictLogin("commTrack", true);
    responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("RELEASED", responseEntity);
    checkOrderStatus(65, "READY_TO_PACK", responseEntity);

    dbWrapper.assignRight("store in-charge", "MANAGE_POD");

    OrderPOD OrderPODFromJson = JsonUtility.readObjectFromFile(FULL_JSON_POD_TXT_FILE_NAME, OrderPOD.class);
    OrderPODFromJson.getPodLineItems().get(0).setQuantityReceived(65);
    OrderPODFromJson.getPodLineItems().get(0).setProductCode("P10");

    String orderId = generateOrderNumberForIdAndDefaultConfiguration(id, "HIV");

    client.SendJSON(getJsonStringFor(OrderPODFromJson),
      format(POD_URL, orderId),
      "POST",
      "commTrack",
      "Admin123");

    responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    checkRequisitionStatus("RELEASED", responseEntity);
    checkOrderStatus(65, "RECEIVED", responseEntity);
    dbWrapper.setupOrderNumberConfiguration("P", true, true, true, true);
    checkOrderNumber(orderId, responseEntity);
  }

  private String generateOrderNumberForIdAndDefaultConfiguration(Long id, String programCode) {
    return "O" + programCode + String.format("%08d", id) + "R";
  }

  private void checkRequisitionStatus(String requisitionStatus, ResponseEntity responseEntity) {
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"programCode\":\"HIV\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"agentCode\":\"F10\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"emergency\":false"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"stringPeriodStartDate\":\"01/12/2012\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"stringPeriodEndDate\":\"01/12/2015\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"periodStartDate\":"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"periodEndDate\":"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"requisitionStatus\":\"" + requisitionStatus + "\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"products\":[{"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"productCode\":\"P10\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"beginningBalance\":0"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"quantityReceived\":11"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"quantityDispensed\":1"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"totalLossesAndAdjustments\":0"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"stockInHand\":10"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"newPatientCount\":0"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"stockOutDays\":0"));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"skipped\":false"));
    assertEquals(200, responseEntity.getStatus());
  }

  private void checkOrderDetailsNotPresent(ResponseEntity responseEntity) {
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"quantityRequested\":3"));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"reasonForRequestedQuantity\":\"reason\""));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"calculatedOrderQuantity\":57"));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"quantityApproved\":57"));
    assertFalse("Response entity : " + responseEntity.getResponse(),
      responseEntity.getResponse().contains("\"quantityRequested\":3"));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"reasonForRequestedQuantity\":\"reason\""));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"calculatedOrderQuantity\":57"));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"quantityApproved\":57"));
    assertTrue("Response entity : " + responseEntity.getResponse(),
      responseEntity.getResponse().contains("\"skipped\":false"));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"remarks\":\"1\""));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"orderStatus\":"));
    assertFalse("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"supplyingFacilityCode\""));

  }

  private void checkOrderStatus(int quantityApproved, String orderStatus, ResponseEntity responseEntity) {
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"quantityApproved\":" + quantityApproved));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"supplyingFacilityCode\":\"F10\""));
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"orderStatus\":\"" + orderStatus + "\""));
  }

  private void checkOrderNumber(String orderId, ResponseEntity responseEntity) {
    assertTrue("Response entity : " + responseEntity.getResponse(), responseEntity.getResponse().contains("\"orderId\":\"" + orderId + "\""));
  }

  private ResponseEntity waitUntilOrderStatusUpdatedOrTimeOut(long id, String expected) throws InterruptedException {
    HttpClient client = new HttpClient();
    client.createContext();
    ResponseEntity responseEntity;

    responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
    int time = 0;
    while (time <= 30000) {
      if (responseEntity.getResponse().contains(expected))
        break;
      responseEntity = client.SendJSON("", URL + id, "GET", "commTrack", "Admin123");
      time += 500;
      Thread.sleep(500);
    }
    return responseEntity;
  }

}