# fop4apex [![Quality Gate Status](https://sonarcloud.io/api/project_badges/measure?project=omaster395464gh_fop4apex&metric=alert_status)](https://sonarcloud.io/summary/new_code?id=omaster395464gh_fop4apex)[![Technical Debt](https://sonarcloud.io/api/project_badges/measure?project=omaster395464gh_fop4apex&metric=sqale_index)](https://sonarcloud.io/summary/new_code?id=omaster395464gh_fop4apex)  [![Codacy Badge](https://app.codacy.com/project/badge/Grade/922bb36eaea346e3871fbb4564ad55f6)](https://app.codacy.com/gh/omaster395464gh/fop4apex/dashboard?utm_source=gh&utm_medium=referral&utm_content=&utm_campaign=Badge_grade)

Servlet for Oracle APEX to run PDF Reports based on Apache FOP

Fahrdienst-Anwendung / Kostenblatt 

* Uses Apache FOP for rendering
<https://xmlgraphics.apache.org/fop/>
* Uses JavaMelody for monitoring
<https://github.com/javamelody/javamelody/wiki>
* Use Java 11 LTS (also tested with Java 17 LTS and Java 21 LTS)
 
## Run tests

`mvn test`

## Build

`mvn package verify`

## Upgrade

* set new version in pom.xml
* check dependent libraries for updates
* run tests and build

## Release

* create a tag with version number
* create a github release

## Installation

* rename target/fop4apex*.war to fop4apex.war
* copy fop4apex.war to tomcat webapps folder
* Oracle APEX - Sample Settings
  * PrintServer	External (Apache FOP)
  * Protocol HTTP / HTTPS
  * Host 127.0.0.1
  * Port 8080
  * Script: /fop4apex/pdf
  * Timeout 300

### Debugging

Add to Tomcat logging.properties:
```
org.apache.tomcat.util.http.Parameters.level = ALL
de.pdv.apex.level = ALL
```

### Deploy to tomcat 9.x (IntelliJ / Netbeans) / Jetty 10.x

Run http://localhost:port/

Example:
* http://localhost:8080/fop4apex_war_exploded/
* http://localhost:8080/fop4apex_war_exploded/monitoring

## Conversion using Apache fop (windows powershell)

```
$env:PATH="c:\Users\oliver1\Downloads\_tools\fop-2.9\fop;$env:PATH"
cd src\test\ressources\samples
fop.cmd  -xsl kostenblatt_2014.xsl    -xml kostenblatt_2014.xml    -pdf Result2014.pdf
fop.cmd  -xsl kostenblatt_2023_vh.xsl -xml kostenblatt_2023_vh.xml -pdf Result2023_vh.pdf
fop.cmd  -xsl kostenblatt_2023_e.xsl  -xml kostenblatt_2023_e.xml  -pdf Result2023_e.pdf
start Result.pdf
```