/**
* MPESA - Import has expected errors due to invalid data and overpayment amount and user is not
* able to continue http://mifosforge.jira.com/browse/MIFOSTEST-692
*
* @throws Exception
*/
@SuppressWarnings("PMD.SignatureDeclareThrowsException")
@Test(enabled = true)
public void failImportTransaction() throws Exception {
// Given
String path = this.getClass().getResource("/mpesa/" + FILE_WITH_OVERPAYMENT_AMOUNT).toString();
String dataset = "mpesa_export_dbunit.xml";
initRemote.dataLoadAndCacheRefresh(dbUnitUtilities, dataset, dataSource, selenium);
propertiesHelper.setImportTransactionOrder("AL3,AL5");
SavingsAccountHelper savingsAccountHelper = new SavingsAccountHelper(selenium);
savingsAccountHelper.closeSavingsAccount("000100000000019", "Close account");
// When
ImportTransactionsPage importTransactionsPage = importTransaction(path);
importTransactionsPage.checkErrors(
new String[] {
"Row <24> error - THY89933"
+ " - Last account is a loan account but the total paid in amount"
+ " is greater than the total due amount"
});
// Then
LoanAccountPage loanAccountPage = navigationHelper.navigateToLoanAccountPage("000100000000013");
loanAccountPage.verifyStatus(LoanAccountPage.ACTIVE);
loanAccountPage.verifyExactLoanAmount("2,000");
TransactionHistoryPage transactionHistoryPage =
loanAccountPage.navigateToTransactionHistoryPage();
transactionHistoryPage.verifyTransactionHistory(183, 1, 6);
}
@SuppressWarnings("PMD.SignatureDeclareThrowsException")
// one of the dependent methods throws Exception
public void viewExistingLoanProduct() throws Exception {
initRemote.dataLoadAndCacheRefresh(
dbUnitUtilities, "acceptance_small_001_dbunit.xml", dataSource, selenium);
ViewLoanProductsPage viewLoanProducts = loginAndNavigateToViewLoanProductsPage();
LoanProductDetailsPage loanProductDetailsPage =
viewLoanProducts.viewLoanProductDetails("FlatInterestLoanProduct1");
loanProductDetailsPage.verifyPage();
}
/**
* MPESA - Import has errors and user chooses to import a different file with some valid and
* invalid data. http://mifosforge.jira.com/browse/MIFOSTEST-695
*
* @throws Exception
*/
@SuppressWarnings("PMD.SignatureDeclareThrowsException")
@Test(enabled = true)
public void importTheSameFiles() throws Exception {
// Given
DateTimeUpdaterRemoteTestingService dateTimeUpdaterRemoteTestingService =
new DateTimeUpdaterRemoteTestingService(selenium);
DateTime targetTime = new DateTime(2011, 01, 28, 12, 0, 0, 0);
dateTimeUpdaterRemoteTestingService.setDateTime(targetTime);
String path = this.getClass().getResource("/mpesa/" + FILE_WITH_NO_ERRORS).toString();
String dataset = "mpesa_export_dbunit.xml";
initRemote.dataLoadAndCacheRefresh(dbUnitUtilities, dataset, dataSource, selenium);
propertiesHelper.setImportTransactionOrder("AL3,AL5");
// When
AdminPage adminPage = navigationHelper.navigateToAdminPage();
ImportTransactionsPage importTransactionsPage = adminPage.navigateToImportTransactionsPage();
ImportTransactionsConfirmationPage importTransactionsConfirmationPage =
importTransactionsPage.importTransactions(path, EXCEL_IMPORT_TYPE);
// Then
importTransactionsConfirmationPage.verifyImportSuccess(
"You have successfully imported transactions.");
LoanAccountPage loanAccountPage = navigationHelper.navigateToLoanAccountPage("000100000000013");
loanAccountPage.verifyStatus(LoanAccountPage.CLOSED);
ViewRepaymentSchedulePage viewRepaymentSchedulePage =
loanAccountPage.navigateToRepaymentSchedulePage();
viewRepaymentSchedulePage.verifyFirstInstallmentDate(5, 3, "28-Jan-2011");
loanAccountPage = viewRepaymentSchedulePage.navigateToLoanAccountPage();
loanAccountPage.verifyPerformanceHistory("11", "11");
TransactionHistoryPage transactionHistoryPage =
loanAccountPage.navigateToTransactionHistoryPage();
transactionHistoryPage.verifyTransactionHistory(2013, 2, 48);
transactionHistoryPage.verifyPostedBy("mifos", 48);
SavingsAccountDetailPage savingsAccountDetailPage =
navigationHelper.navigateToSavingsAccountDetailPage("000100000000015");
savingsAccountDetailPage.verifySavingsAmount("3170.0");
savingsAccountDetailPage.verifyDate("28/01/2011");
// When
adminPage = navigationHelper.navigateToAdminPage();
importTransactionsPage = adminPage.navigateToImportTransactionsPage();
importTransactionsPage = importTransactionsPage.failImportTransaction(path, EXCEL_IMPORT_TYPE);
// Then
importTransactionsPage.checkErrors(
new String[] {"Same file has been already imported. Please import a different file."});
}
@SuppressWarnings("PMD.SignatureDeclareThrowsException")
@Test(
sequential = true,
groups = {"savings", "acceptance", "ui"})
public void newMandatoryGroupSavingsAccount() throws Exception {
initRemote.dataLoadAndCacheRefresh(
dbUnitUtilities, "acceptance_small_008_dbunit.xml.zip", dataSource, selenium);
CreateSavingsAccountSearchParameters searchParameters =
new CreateSavingsAccountSearchParameters();
searchParameters.setSearchString("MyGroup1232993846342");
searchParameters.setSavingsProduct("MandGroupSavingsPerIndiv1MoPost");
CreateSavingsAccountSubmitParameters submitAccountParameters =
new CreateSavingsAccountSubmitParameters();
submitAccountParameters.setAmount("534.0");
verifySavingsAccountCreation(searchParameters, submitAccountParameters);
}
@SuppressWarnings("PMD.SignatureDeclareThrowsException")
@Test(
sequential = true,
groups = {"smoke", "savings", "acceptance", "ui"})
public void newVoluntaryClientSavingsAccount() throws Exception {
initRemote.dataLoadAndCacheRefresh(
dbUnitUtilities, "acceptance_small_008_dbunit.xml.zip", dataSource, selenium);
CreateSavingsAccountSearchParameters searchParameters =
new CreateSavingsAccountSearchParameters();
searchParameters.setSearchString("Stu1233266079799 Client1233266079799");
searchParameters.setSavingsProduct("VolClientSavings3MoPost");
CreateSavingsAccountSubmitParameters submitAccountParameters =
new CreateSavingsAccountSubmitParameters();
submitAccountParameters.setAmount("200.0");
verifySavingsAccountCreation(searchParameters, submitAccountParameters);
}
@SuppressWarnings({"PMD.SignatureDeclareThrowsException", "PMD.SystemPrintln"})
@Test(enabled = true)
public void importMpesaTransactions() throws Exception {
AdminPage adminPage = navigationHelper.navigateToAdminPage();
ViewOrganizationSettingsPage viewOrganizationSettingsPage =
adminPage.navigateToViewOrganizationSettingsPage();
viewOrganizationSettingsPage.verifyMiscellaneous(
new String[] {"Max MPESA Disbursal Limit: 50000.0"});
propertiesHelper.setImportTransactionOrder("AL3,AL5");
String dataset = "mpesa_export_dbunit.xml";
initRemote.dataLoadAndCacheRefresh(dbUnitUtilities, dataset, dataSource, selenium);
for (String importFile : TEST_FILES) {
String path = this.getClass().getResource("/mpesa/" + importFile).toString();
importTransaction(path);
checkIfOutputMatchesExpected(path);
}
}
/**
* Digits after decimal validate occurs for disbursal and payment import
* http://mifosforge.jira.com/browse/MIFOSTEST-278
*
* @throws Exception
*/
@SuppressWarnings("PMD.SignatureDeclareThrowsException")
@Test(enabled = true)
public void validateImport() throws Exception {
// Given
String path = this.getClass().getResource("/mpesa/" + DISBURSAL_IMPORT).toString();
String dataset = "mpesa_export_dbunit.xml";
initRemote.dataLoadAndCacheRefresh(dbUnitUtilities, dataset, dataSource, selenium);
propertiesHelper.setImportTransactionOrder("AL3,AL5");
propertiesHelper.setDigitsAfterDecimal(0);
// When
ImportTransactionsPage importTransactionsPage = importTransaction(path);
// Then
importTransactionsPage.checkErrors(
new String[] {
"Row <24> error - "
+ "C94ZH942 - Number of fraction digits in the \"Withdrawn\""
+ " column - 3 - is greater than configured for the currency - 0"
});
// When
path = this.getClass().getResource("/mpesa/" + PAYMENT_IMPORT).toString();
importTransactionsPage = importTransaction(path);
// Then
importTransactionsPage.checkErrors(
new String[] {
"Row <24> error - THY89933"
+ " - Number of fraction digits in the \"Paid In\" column - 3 - "
+ "is greater than configured for the currency - 0"
});
propertiesHelper.setDigitsAfterDecimal(1);
}
@SuppressWarnings("PMD.SignatureDeclareThrowsException")
// one of the dependent methods throws Exception
public void editExistingLoanProduct() throws Exception {
initRemote.dataLoadAndCacheRefresh(
dbUnitUtilities, "acceptance_small_001_dbunit.xml", dataSource, selenium);
ViewLoanProductsPage viewLoanProducts = loginAndNavigateToViewLoanProductsPage();
LoanProductDetailsPage loanProductDetailsPage =
viewLoanProducts.viewLoanProductDetails("FlatInterestLoanProduct1");
EditLoanProductPage editLoanProductPage = loanProductDetailsPage.editLoanProduct();
editLoanProductPage.verifyPage();
SubmitFormParameters formParameters = new SubmitFormParameters();
formParameters.setDescription("Modified Description");
formParameters.setMaxInterestRate("44");
formParameters.setMinInterestRate("3");
formParameters.setDefaultInterestRate("18");
EditLoanProductPreviewPage editLoanProductPreviewPage =
editLoanProductPage.submitDescriptionAndInterestChanges(formParameters);
loanProductDetailsPage = editLoanProductPreviewPage.submit();
loanProductDetailsPage.verifyPage();
loanProductDetailsPage.editLoanProduct();
editLoanProductPage.verifyPage();
editLoanProductPage.verifyModifiedDescriptionAndInterest(formParameters);
}
/**
* MPESA - Import transactions from file with no errors
* http://mifosforge.jira.com/browse/MIFOSTEST-688
*
* @throws Exception
*/
@SuppressWarnings({"PMD.SignatureDeclareThrowsException", "PMD.SystemPrintln"})
@Test(enabled = true)
public void importTransactionsFromFileWithNoErrors() throws Exception {
DateTimeUpdaterRemoteTestingService dateTimeUpdaterRemoteTestingService =
new DateTimeUpdaterRemoteTestingService(selenium);
DateTime targetTime = new DateTime(2011, 01, 28, 12, 0, 0, 0);
dateTimeUpdaterRemoteTestingService.setDateTime(targetTime);
AdminPage adminPage = navigationHelper.navigateToAdminPage();
ViewRolesPage viewRolesPage = adminPage.navigateToViewRolesPage();
ManageRolePage manageRolePage = viewRolesPage.navigateToManageRolePage("Admin");
manageRolePage.disablePermission("8_3");
viewRolesPage = manageRolePage.submitAndGotoViewRolesPage();
adminPage = viewRolesPage.navigateToAdminPage();
adminPage = adminPage.failNavigationToImportTransactionsPage();
adminPage.verifyError(
"You do not have permissions to perform "
+ "this activity. Contact your system administrator "
+ "to grant you the required permissions and try again.");
viewRolesPage = adminPage.navigateToViewRolesPage();
manageRolePage = viewRolesPage.navigateToManageRolePage("Admin");
manageRolePage.enablePermission("8_3");
viewRolesPage = manageRolePage.submitAndGotoViewRolesPage();
propertiesHelper.setImportTransactionOrder("AL3,AL5");
String dataset = "mpesa_export_dbunit.xml";
initRemote.dataLoadAndCacheRefresh(dbUnitUtilities, dataset, dataSource, selenium);
String path = this.getClass().getResource("/mpesa/" + FILE_WITH_NO_ERRORS).toString();
ImportTransactionsPage importTransactionsPage = importTransaction(path);
checkIfOutputMatchesExpected(path);
importTransactionsPage.cancelImportTransaction();
LoanAccountPage loanAccountPage = navigationHelper.navigateToLoanAccountPage("000100000000013");
loanAccountPage.verifyStatus(LoanAccountPage.ACTIVE);
loanAccountPage.verifyExactLoanAmount("2,000");
SavingsAccountDetailPage savingsAccountDetailPage =
navigationHelper.navigateToSavingsAccountDetailPage("000100000000015");
savingsAccountDetailPage.verifySavingsAmount("0");
adminPage = navigationHelper.navigateToAdminPage();
importTransactionsPage = adminPage.navigateToImportTransactionsPage();
ImportTransactionsConfirmationPage importTransactionsConfirmationPage =
importTransactionsPage.importTransactions(path, EXCEL_IMPORT_TYPE);
importTransactionsConfirmationPage.verifyImportSuccess(
"You have successfully imported transactions.");
loanAccountPage = navigationHelper.navigateToLoanAccountPage("000100000000013");
loanAccountPage.verifyStatus(LoanAccountPage.CLOSED);
ViewRepaymentSchedulePage viewRepaymentSchedulePage =
loanAccountPage.navigateToRepaymentSchedulePage();
viewRepaymentSchedulePage.verifyFirstInstallmentDate(5, 3, "28-Jan-2011");
loanAccountPage = viewRepaymentSchedulePage.navigateToLoanAccountPage();
loanAccountPage.verifyPerformanceHistory("11", "11");
TransactionHistoryPage transactionHistoryPage =
loanAccountPage.navigateToTransactionHistoryPage();
transactionHistoryPage.verifyTransactionHistory(2013, 2, 48);
transactionHistoryPage.verifyPostedBy("mifos", 48);
savingsAccountDetailPage =
navigationHelper.navigateToSavingsAccountDetailPage("000100000000015");
savingsAccountDetailPage.verifySavingsAmount("3170.0");
savingsAccountDetailPage.verifyDate("28/01/2011");
}
