// odi.614 Able to generate reports for time range
public void search() {
String dmName = "US_AIRWAYS";
gotoreports(dmName);
try {
driver.findElement(By.id("PARAM_START_DATE")).clear();
Alert alert = driver.switchTo().alert();
alert.dismiss();
driver.findElement(By.id("PARAM_START_DATE")).sendKeys("8/11/2013");
driver.findElement(By.id("PARAM_END_DATE")).clear();
alert.dismiss();
driver.findElement(By.id("PARAM_END_DATE")).sendKeys("9/11/2013");
driver.findElement(By.cssSelector("input[type=\"submit\"]")).click();
driver.manage().timeouts().implicitlyWait(20, TimeUnit.SECONDS);
new WebDriverWait(driver, 10)
.until(ExpectedConditions.frameToBeAvailableAndSwitchToIt("reportContent"));
WebElement page =
new WebDriverWait(driver, 10)
.until(ExpectedConditions.visibilityOfElementLocated(By.id("CrystalViewer")));
WebElement rangeStart = page.findElement(By.xpath("//*[contains(text(),'8/11/2013')]"));
WebElement rangeEnd = page.findElement(By.xpath("//*[contains(text(),'9/11/2013')]"));
if (rangeStart != null && rangeEnd != null) {
System.out.println("Report for selected range is showed");
}
ReportFile = new WriteXmlFile();
driver.switchTo().defaultContent();
ReportFile.addTestCase("ODI6.x-614:CSSR-Search", "ODI6.x-614:CSSR-Search => Pass");
} catch (Exception e) {
System.out.print("trace: ");
e.printStackTrace();
}
// driver.quit();
ReportFile.WriteToFile();
}
// ODI6.x-628:Number formatting
public void numberFormat() {
String dmName = "US_AIRWAYS";
gotoreports(dmName);
pickAvalidDate();
try {
new WebDriverWait(driver, 10)
.until(ExpectedConditions.frameToBeAvailableAndSwitchToIt("reportContent"));
WebElement page =
new WebDriverWait(driver, 10)
.until(ExpectedConditions.visibilityOfElementLocated(By.id("CrystalViewer")));
List<WebElement> check = page.findElements(By.tagName("span"));
for (int i = 0; i < check.size(); i++) {
content = check.get(i).getText();
if (content.equals("Call Volume")) {
contentValue = check.get(i + 1).getText();
System.out.println(contentValue);
decimalcheck(contentValue, "example", 0);
System.out.println(contentValue);
}
if (content.equals("Call Duration (minutes)")) {
contentValue = check.get(i + 1).getText();
decimalcheck(contentValue, "In call duration", 2);
} else if (content.equals("Average Call Duration (minutes)")) {
contentValue = check.get(i + 1).getText();
decimalcheck(contentValue, "In average call duration", 2);
} else if (content.equals("Average Call Duration for Transferred Calls (minutes)")) {
contentValue = check.get(i + 1).getText();
decimalcheck(contentValue, "In average call duration for transfered calls", 2);
} else if (content.equals("Peak Hour Average Call Duration (minutes)")) {
contentValue = check.get(i + 1).getText();
decimalcheck(contentValue, "In peak hour average call duration", 2);
} else if (content.equals("Average Weekly Call Volume")) {
contentValue = check.get(i + 1).getText();
decimalcheck(contentValue, "Average Weekly call volume", 1);
}
if (content.equals("Transfer Rate (All)")) {
String percentage = check.get(i + 1).getText();
String[] contentValues = percentage.split("%");
contentValue = contentValues[0];
System.out.println(contentValue);
decimalcheck(contentValue, "In Transfer Rate ", 1);
} else if (content.equals("Containment Rate (All)")) {
String percentage = check.get(i + 1).getText();
String[] contentValues = percentage.split("%");
contentValue = contentValues[0];
System.out.println(contentValue);
// System.out.println(NumberFormat.getNumberInstance(Locale.US).format(contentValue));
decimalcheck(contentValue, "In Containment Rate ", 1);
}
}
ReportFile.addTestCase(
"ODI6.x-628:CSSR numbers Formatting", "ODI6.x-628:CSSR numbers Formatting => Pass");
} catch (Exception e) {
driver.quit();
e.printStackTrace();
}
driver.quit();
}
// odi.618 Method for finding the lables of filters
public void findthelables() {
String dmname = "US_AIRWAYS";
gotoreports(dmname);
try {
driver.manage().timeouts().implicitlyWait(20, TimeUnit.SECONDS);
isElementpresent(Element1, By.id("date_range_label"));
isElementpresent(Element2, By.id("PARAM_START_DATE_label"));
isElementpresent(Element3, By.id("PARAM_END_DATE_label"));
isElementpresent(Element4, By.id("PARAM_TIME_ZONE_label"));
isElementpresent(Element5, By.id("PARAM_APP_ID_label"));
isElementpresent(Element6, By.id("PARAM_DNIS_label"));
isElementpresent(Element7, By.id("PARAM_LOCALE_label"));
ReportFile.addTestCase(
"ODI6.x-618:Labeling of Call Stat Summary filters",
"ODI6.x-618:Labeling of Call Stat Summary filters => Pass");
} catch (Exception e) {
System.out.print("trace: ");
e.printStackTrace();
}
ReportFile.WriteToFile();
}
// odi.623.Method for DNIS value search
public void dnisfilter() {
String dmName = "US_AIRWAYS";
gotoreports(dmName);
try {
WebElement DNISvalue = driver.findElement(By.id("PARAM_DNIS"));
Select select = new Select(DNISvalue);
select.deselectAll();
select.selectByValue("2404953077");
driver
.manage()
.timeouts()
.implicitlyWait(
20,
TimeUnit
.SECONDS); // submit should be clickable if delay is there in selecting the DNIS
driver.findElement(By.cssSelector("input[type=\"submit\"]")).click();
new WebDriverWait(driver, 10)
.until(ExpectedConditions.frameToBeAvailableAndSwitchToIt("reportContent"));
WebElement page =
new WebDriverWait(driver, 10)
.until(ExpectedConditions.visibilityOfElementLocated(By.id("CrystalViewer")));
WebElement tag = page.findElement(By.xpath("//*[contains(text(),'2404953077')]"));
if (tag != null) {
System.out.println("DNIS:2404953077 filter is present");
ReportFile.addTestCase(
"ODI6.x-623:DNIS filter: selected DNIS filter should be shown in report result",
"ODI6.x-623:DNIS filter: selected DNIS filter should be shown in report result => Pass");
}
} catch (Exception e) {
System.out.print("trace: ");
e.printStackTrace();
}
// driver.quit();
ReportFile.WriteToFile();
driver.switchTo().defaultContent();
}
// odi.620 Method that the report footer a/b filter should match all as it specified in left side
// panel
public void abfilter() {
String dmName = "METROPCS";
gotoreports(dmName);
try {
driver.findElement(By.cssSelector("input[type=\"submit\"]")).click();
new WebDriverWait(driver, 10)
.until(ExpectedConditions.frameToBeAvailableAndSwitchToIt("reportContent"));
WebElement page =
new WebDriverWait(driver, 10)
.until(ExpectedConditions.visibilityOfElementLocated(By.id("CrystalViewer")));
WebElement tag = page.findElement(By.xpath("//*[contains(text(),'A/B')]"));
if (tag != null) {
System.out.println("A/B Combo ID: NVP 5.0.0-NDF 6.1.0-0.0.0.1 filter is present");
ReportFile.addTestCase(
"ODI6.x-620:A/B filter: should be in the report footer",
"ODI6.x-620:A/B filter: should be in the report footer => Pass");
}
} catch (Exception e) {
System.out.print("trace: ");
e.printStackTrace();
}
}
// ODI6.x-627:generate cssr report with valid filters and check the number if they are reasonable
public void cssrNumbers() {
int CallVolumeValue = 0, TransfersValue = 0, PeakHourValue = 0;
double roundOff = 0, AverageCallValue = 0;
String dmName = "US_AIRWAYS";
gotoreports(dmName);
pickAvalidDate();
try {
new WebDriverWait(driver, 10)
.until(ExpectedConditions.frameToBeAvailableAndSwitchToIt("reportContent"));
WebElement page =
new WebDriverWait(driver, 10)
.until(ExpectedConditions.visibilityOfElementLocated(By.id("CrystalViewer")));
List<WebElement> check = page.findElements(By.tagName("span"));
for (int i = 0; i < check.size(); i++) {
String content = (check.get(i).getText());
if (content.equals("Call Volume")) {
String CallVolume = (check.get(i + 1).getText());
String[] CallVolumes = CallVolume.split("\\s");
CallVolumeValue = Integer.parseInt(CallVolumes[1]);
System.out.println(CallVolumeValue);
} else if (content.equals("Transfers (All)")) {
String TransfersAll = (check.get(i + 1).getText());
String[] Tvalues = TransfersAll.split("\\s");
TransfersValue = Integer.parseInt(Tvalues[1]);
System.out.println(TransfersValue);
} else if (content.equals("Peak Hour Call Volume")) {
String PeakHourCallVolume = (check.get(i + 1).getText());
String[] PeakHourCallValues = PeakHourCallVolume.split("\\s");
PeakHourValue = Integer.parseInt(PeakHourCallValues[1]);
} else if (content.equals("Call Duration (minutes)")) {
String CallDuration = (check.get(i + 1).getText());
String[] CallDurationValues = CallDuration.split("\\s");
double CallDurationValue = Double.parseDouble(CallDurationValues[1]);
double x = CallDurationValue / CallVolumeValue;
roundOff = Math.round(x * 100.0) / 100.0;
} else if (content.equals("Average Call Duration (minutes)")) {
String AverageCallDuration = (check.get(i + 1).getText());
String[] AverageCallDurationValues = AverageCallDuration.split("\\s");
AverageCallValue = Double.parseDouble(AverageCallDurationValues[1]);
}
}
try {
if (CallVolumeValue >= TransfersValue) {
logger.info("the call volume is greater than the Transfer");
System.out.println("CallVolumeValue >= TransfersValue");
}
if (PeakHourValue <= CallVolumeValue) {
System.out.println("PeakHourValue <= CallVolumeValue");
}
if (AverageCallValue == roundOff) {
System.out.println("Average Call Duration =Call Duration (minutes)/Call Volume");
}
} catch (Exception e) {
e.printStackTrace();
}
ReportFile.addTestCase(
"ODI6.x-627:CSSR numbers must be reasonable",
"ODI6.x-627:CSSR numbers must be reasonable => Pass");
} catch (Exception e) {
e.printStackTrace();
}
ReportFile.WriteToFile();
driver.quit();
}
