io.syndesis.connector.sheets.GoogleSheetsAddChartCustomizer Maven / Gradle / Ivy
The newest version!
/*
* Copyright (C) 2016 Red Hat, Inc.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package io.syndesis.connector.sheets;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collections;
import java.util.List;
import java.util.Map;
import java.util.Optional;
import java.util.stream.Stream;
import com.google.api.services.sheets.v4.model.AddChartRequest;
import com.google.api.services.sheets.v4.model.BasicChartAxis;
import com.google.api.services.sheets.v4.model.BasicChartDomain;
import com.google.api.services.sheets.v4.model.BasicChartSeries;
import com.google.api.services.sheets.v4.model.BasicChartSpec;
import com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest;
import com.google.api.services.sheets.v4.model.ChartData;
import com.google.api.services.sheets.v4.model.ChartSourceRange;
import com.google.api.services.sheets.v4.model.ChartSpec;
import com.google.api.services.sheets.v4.model.EmbeddedChart;
import com.google.api.services.sheets.v4.model.EmbeddedObjectPosition;
import com.google.api.services.sheets.v4.model.GridCoordinate;
import com.google.api.services.sheets.v4.model.GridRange;
import com.google.api.services.sheets.v4.model.OverlayPosition;
import com.google.api.services.sheets.v4.model.PieChartSpec;
import com.google.api.services.sheets.v4.model.Request;
import io.syndesis.connector.sheets.model.CellCoordinate;
import io.syndesis.connector.sheets.model.GoogleChart;
import io.syndesis.connector.sheets.model.RangeCoordinate;
import io.syndesis.connector.support.util.ConnectorOptions;
import io.syndesis.integration.component.proxy.ComponentProxyComponent;
import io.syndesis.integration.component.proxy.ComponentProxyCustomizer;
import org.apache.camel.Exchange;
import org.apache.camel.Message;
import org.apache.camel.component.google.sheets.internal.GoogleSheetsApiCollection;
import org.apache.camel.component.google.sheets.internal.GoogleSheetsConstants;
import org.apache.camel.component.google.sheets.internal.SheetsSpreadsheetsApiMethod;
import org.apache.camel.component.google.sheets.stream.GoogleSheetsStreamConstants;
import org.apache.camel.util.ObjectHelper;
public class GoogleSheetsAddChartCustomizer implements ComponentProxyCustomizer {
private String spreadsheetId;
private String title;
private String subtitle;
@Override
public void customize(ComponentProxyComponent component, Map options) {
setApiMethod(options);
component.setBeforeProducer(this::beforeProducer);
}
private void setApiMethod(Map options) {
spreadsheetId = ConnectorOptions.extractOption(options, "spreadsheetId");
title = ConnectorOptions.extractOption(options, "title");
subtitle = ConnectorOptions.extractOption(options, "subtitle");
options.put("apiName",
GoogleSheetsApiCollection.getCollection().getApiName(SheetsSpreadsheetsApiMethod.class).getName());
options.put("methodName", "batchUpdate");
}
private void beforeProducer(Exchange exchange) {
final Message in = exchange.getIn();
final GoogleChart model = exchange.getIn().getBody(GoogleChart.class);
if (model != null) {
if (ObjectHelper.isNotEmpty(model.getSpreadsheetId())) {
spreadsheetId = model.getSpreadsheetId();
}
if (ObjectHelper.isNotEmpty(model.getTitle())) {
title = model.getTitle();
}
if (ObjectHelper.isNotEmpty(model.getSubtitle())) {
subtitle = model.getSubtitle();
}
}
BatchUpdateSpreadsheetRequest batchUpdateRequest = new BatchUpdateSpreadsheetRequest();
batchUpdateRequest.setIncludeSpreadsheetInResponse(true);
batchUpdateRequest.setRequests(new ArrayList<>());
AddChartRequest addChartRequest = new AddChartRequest();
batchUpdateRequest.getRequests().add(new Request().setAddChart(addChartRequest));
ChartSpec chartSpec = createChartSpec(title, subtitle);
if (model != null) {
addChartRequest.setChart(createEmbeddedChart(model, chartSpec));
if (model.getBasicChart() != null) {
addBasicChart(chartSpec, model);
} else if (model.getPieChart() != null) {
addPieChart(chartSpec, model);
}
} else {
addChartRequest.setChart(createEmptyChart(chartSpec));
}
in.setHeader(GoogleSheetsStreamConstants.SPREADSHEET_ID, spreadsheetId);
in.setHeader(GoogleSheetsConstants.PROPERTY_PREFIX + "batchUpdateSpreadsheetRequest", batchUpdateRequest);
}
private static ChartSpec createChartSpec(String title, String subtitle) {
ChartSpec chartSpec = new ChartSpec();
if (ObjectHelper.isNotEmpty(title)) {
chartSpec.setTitle(title);
}
if (ObjectHelper.isNotEmpty(subtitle)) {
chartSpec.setSubtitle(subtitle);
}
return chartSpec;
}
private static EmbeddedChart createEmptyChart(ChartSpec chartSpec) {
EmbeddedChart embeddedChart = new EmbeddedChart();
EmbeddedObjectPosition position = new EmbeddedObjectPosition();
position.setNewSheet(true);
embeddedChart.setPosition(position);
embeddedChart.setSpec(chartSpec);
return embeddedChart;
}
private static EmbeddedChart createEmbeddedChart(GoogleChart model, ChartSpec chartSpec) {
Integer sourceSheetId = Optional.ofNullable(model.getSourceSheetId())
.orElse(0);
Integer sheetId = Optional.ofNullable(model.getSheetId())
.orElse(sourceSheetId);
EmbeddedChart embeddedChart = new EmbeddedChart();
EmbeddedObjectPosition position = new EmbeddedObjectPosition();
if (ObjectHelper.isNotEmpty(model.getOverlayPosition())) {
CellCoordinate cellCoordinate = CellCoordinate.fromCellId(model.getOverlayPosition());
position.setOverlayPosition(new OverlayPosition().setAnchorCell(new GridCoordinate()
.setSheetId(sheetId)
.setColumnIndex(cellCoordinate.getColumnIndex())
.setRowIndex(cellCoordinate.getRowIndex())));
} else {
position.setNewSheet(true);
}
embeddedChart.setPosition(position);
embeddedChart.setSpec(chartSpec);
return embeddedChart;
}
private static void addPieChart(ChartSpec chartSpec, GoogleChart model) {
Integer sheetId = Optional.ofNullable(model.getSheetId())
.orElse(0);
Integer sourceSheetId = Optional.ofNullable(model.getSourceSheetId())
.orElse(sheetId);
GoogleChart.PieChart pieChart = model.getPieChart();
PieChartSpec pieChartSpec = new PieChartSpec();
pieChartSpec.setLegendPosition(pieChart.getLegendPosition());
pieChartSpec.setDomain(new ChartData().setSourceRange(getDomainSourceRange(sourceSheetId, pieChart.getDomainRange())));
ChartSourceRange sourceRange = new ChartSourceRange();
GridRange gridRange = new GridRange();
gridRange.setSheetId(sourceSheetId);
RangeCoordinate coordinates = RangeCoordinate.fromRange(pieChart.getDataRange());
gridRange.setStartRowIndex(coordinates.getRowStartIndex());
gridRange.setEndRowIndex(coordinates.getRowEndIndex());
gridRange.setStartColumnIndex(coordinates.getColumnStartIndex());
gridRange.setEndColumnIndex(coordinates.getColumnEndIndex());
sourceRange.setSources(Collections.singletonList(gridRange));
pieChartSpec.setSeries(new ChartData().setSourceRange(sourceRange));
chartSpec.setPieChart(pieChartSpec);
}
private static void addBasicChart(ChartSpec chartSpec, GoogleChart model) {
Integer sheetId = Optional.ofNullable(model.getSheetId())
.orElse(0);
Integer sourceSheetId = Optional.ofNullable(model.getSourceSheetId())
.orElse(sheetId);
GoogleChart.BasicChart basicChart = model.getBasicChart();
BasicChartSpec basicChartSpec = new BasicChartSpec();
basicChartSpec.setHeaderCount(1);
BasicChartAxis bottomAxis = new BasicChartAxis();
bottomAxis.setPosition("BOTTOM_AXIS");
bottomAxis.setTitle(Optional.ofNullable(basicChart.getAxisTitleBottom())
.orElse("X-Axis"));
BasicChartAxis leftAxis = new BasicChartAxis();
leftAxis.setPosition("LEFT_AXIS");
leftAxis.setTitle(Optional.ofNullable(basicChart.getAxisTitleLeft())
.orElse("Y-Axis"));
basicChartSpec.setAxis(Arrays.asList(bottomAxis, leftAxis));
BasicChartDomain chartDomain = new BasicChartDomain();
chartDomain.setDomain(new ChartData().setSourceRange(getDomainSourceRange(sourceSheetId, basicChart.getDomainRange())));
basicChartSpec.setDomains(Collections.singletonList(chartDomain));
basicChartSpec.setChartType(basicChart.getType());
List series = new ArrayList<>();
String dataRange = Optional.ofNullable(basicChart.getDataRange()).orElse("");
Stream.of(dataRange.split(",", -1)).forEach(range -> {
ChartSourceRange sourceRange = new ChartSourceRange();
GridRange gridRange = new GridRange();
gridRange.setSheetId(sourceSheetId);
RangeCoordinate coordinate = RangeCoordinate.fromRange(range);
gridRange.setStartRowIndex(coordinate.getRowStartIndex());
gridRange.setEndRowIndex(coordinate.getRowEndIndex());
gridRange.setStartColumnIndex(coordinate.getColumnStartIndex());
gridRange.setEndColumnIndex(coordinate.getColumnEndIndex());
sourceRange.setSources(Collections.singletonList(gridRange));
BasicChartSeries basicChartSeries = new BasicChartSeries();
basicChartSeries.setTargetAxis("LEFT_AXIS");
basicChartSeries.setSeries(new ChartData().setSourceRange(sourceRange));
series.add(basicChartSeries);
});
basicChartSpec.setSeries(series);
chartSpec.setBasicChart(basicChartSpec);
}
private static ChartSourceRange getDomainSourceRange(int sourceSheetId, String domainRange) {
ChartSourceRange domainSourceRange = new ChartSourceRange();
GridRange domainGridRange = new GridRange();
domainGridRange.setSheetId(sourceSheetId);
RangeCoordinate coordinate = RangeCoordinate.fromRange(domainRange);
domainGridRange.setStartRowIndex(coordinate.getRowStartIndex());
domainGridRange.setEndRowIndex(coordinate.getRowEndIndex());
domainGridRange.setStartColumnIndex(coordinate.getRowStartIndex());
domainGridRange.setEndColumnIndex(coordinate.getColumnEndIndex());
domainSourceRange.setSources(Collections.singletonList(domainGridRange));
return domainSourceRange;
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy