App.java 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392
  1. package space.anyi.amountVerification;
  2. import com.alibaba.excel.EasyExcel;
  3. import com.alibaba.excel.read.listener.PageReadListener;
  4. import javafx.application.Application;
  5. import javafx.application.Platform;
  6. import javafx.geometry.Insets;
  7. import javafx.geometry.Pos;
  8. import javafx.scene.Scene;
  9. import javafx.scene.control.Alert;
  10. import javafx.scene.control.Button;
  11. import javafx.scene.control.ButtonType;
  12. import javafx.scene.control.Label;
  13. import javafx.scene.control.Menu;
  14. import javafx.scene.control.MenuBar;
  15. import javafx.scene.control.MenuItem;
  16. import javafx.scene.control.ProgressBar;
  17. import javafx.scene.control.TextField;
  18. import javafx.scene.layout.BorderPane;
  19. import javafx.scene.layout.GridPane;
  20. import javafx.scene.layout.VBox;
  21. import javafx.stage.DirectoryChooser;
  22. import javafx.stage.FileChooser;
  23. import javafx.stage.Stage;
  24. import org.apache.pdfbox.Loader;
  25. import org.apache.pdfbox.pdmodel.PDDocument;
  26. import org.apache.pdfbox.text.PDFTextStripper;
  27. import space.anyi.amountVerification.model.InputModel;
  28. import space.anyi.amountVerification.model.OutputModel;
  29. import java.io.File;
  30. import java.io.IOException;
  31. import java.math.BigDecimal;
  32. import java.util.*;
  33. import java.util.regex.Matcher;
  34. import java.util.regex.Pattern;
  35. /**
  36. * @ProjectName: amount-verification
  37. * @FileName: Application
  38. * @Author: 杨逸
  39. * @Data:2025/11/27 18:33
  40. * @Description:
  41. */
  42. public class App extends Application {
  43. private Stage primaryStage;
  44. /**
  45. * 文件
  46. * @see TextField
  47. */
  48. private TextField fileField;
  49. /**文件夹
  50. * @see TextField
  51. */
  52. private TextField folderField;
  53. /**
  54. * excel输入数据
  55. * @see List<InputModel>
  56. */
  57. private List<InputModel> inputModelList;
  58. /**
  59. * excel输出数据
  60. * @see List<OutputModel>
  61. */
  62. private List<OutputModel> outputModelList;
  63. /**
  64. * IMEI码与PDF文件映射
  65. * @see Map<String, File>
  66. */
  67. private Map<String,File> pdfFileMap;
  68. /**
  69. * 进度条控件
  70. * @see ProgressBar
  71. */
  72. private ProgressBar progressBar;
  73. /**
  74. * 进度标签
  75. * @see Label
  76. */
  77. private Label progressLabel;
  78. /**
  79. * 匹配金额使用的正则表达式对象
  80. * @see Pattern
  81. */
  82. private Pattern pattern;
  83. {
  84. /**
  85. * 代码快初始化匹配金额的正则表达式对象
  86. */
  87. String regex = "理赔金额合计:¥(?<money>\\d+\\.\\d{2})";
  88. this.pattern = Pattern.compile(regex);
  89. }
  90. public static void main(String[] args) {
  91. Application.launch(App.class, args);
  92. }
  93. @Override
  94. public void start(Stage primaryStage) throws Exception {
  95. this.primaryStage = primaryStage;
  96. primaryStage.setTitle("金额验证工具");
  97. primaryStage.setResizable(false);
  98. // 设置窗口关闭事件处理
  99. primaryStage.setOnCloseRequest(event -> {
  100. event.consume(); // 阻止默认关闭行为
  101. showCloseConfirmation(primaryStage);
  102. });
  103. // 创建主布局
  104. BorderPane mainLayout = new BorderPane();
  105. // 创建菜单栏
  106. MenuBar menuBar = createMenuBar();
  107. mainLayout.setTop(menuBar);
  108. // 创建内容区域
  109. VBox contentLayout = new VBox(20);
  110. contentLayout.setPadding(new Insets(20));
  111. contentLayout.setAlignment(Pos.CENTER);
  112. // 创建网格布局用于表单
  113. GridPane gridPane = new GridPane();
  114. gridPane.setHgap(10);
  115. gridPane.setVgap(10);
  116. gridPane.setAlignment(Pos.CENTER);
  117. // 文件选择组件
  118. Label fileLabel = new Label("选择文件:");
  119. fileField = new TextField();
  120. fileField.setPromptText("请选择文件...");
  121. fileField.setPrefWidth(300);
  122. Button fileButton = new Button("浏览");
  123. // 文件夹选择组件
  124. Label folderLabel = new Label("选择文件夹:");
  125. folderField = new TextField();
  126. folderField.setPromptText("请选择文件夹...");
  127. folderField.setPrefWidth(300);
  128. Button folderButton = new Button("浏览");
  129. // 进度条组件
  130. progressBar = new ProgressBar(0);
  131. progressBar.setPrefWidth(300);
  132. progressBar.setVisible(false);
  133. // 进度标签
  134. progressLabel = new Label("准备开始...");
  135. progressLabel.setVisible(false);
  136. // 开始按钮
  137. Button startButton = new Button("开始验证");
  138. startButton.setPrefWidth(150);
  139. startButton.setPrefHeight(40);
  140. // 设置按钮事件
  141. fileButton.setOnAction(e -> chooseFile());
  142. folderButton.setOnAction(e -> chooseFolder());
  143. startButton.setOnAction(e -> startVerification());
  144. // 添加到网格布局
  145. gridPane.add(fileLabel, 0, 0);
  146. gridPane.add(fileField, 1, 0);
  147. gridPane.add(fileButton, 2, 0);
  148. gridPane.add(folderLabel, 0, 1);
  149. gridPane.add(folderField, 1, 1);
  150. gridPane.add(folderButton, 2, 1);
  151. // 添加到内容布局
  152. contentLayout.getChildren().addAll(gridPane, progressLabel, progressBar, startButton);
  153. mainLayout.setCenter(contentLayout);
  154. // 创建场景并显示
  155. Scene scene = new Scene(mainLayout, 500, 400);
  156. primaryStage.setScene(scene);
  157. primaryStage.show();
  158. }
  159. private MenuBar createMenuBar() {
  160. MenuBar menuBar = new MenuBar();
  161. // 创建帮助菜单
  162. Menu helpMenu = new Menu("帮助");
  163. // 创建关于菜单项
  164. MenuItem aboutMenuItem = new MenuItem("关于");
  165. aboutMenuItem.setOnAction(e -> showAboutDialog());
  166. helpMenu.getItems().add(aboutMenuItem);
  167. menuBar.getMenus().add(helpMenu);
  168. return menuBar;
  169. }
  170. private void showAboutDialog() {
  171. Alert alert = new Alert(Alert.AlertType.INFORMATION);
  172. alert.setTitle("关于");
  173. alert.setHeaderText("金额验证工具");
  174. alert.setContentText("作者: 杨逸\n" +
  175. "联系方式: huanglve2004@163.com\n\n" +
  176. "版本: 1.0.0\n" +
  177. "描述: 用于金额验证的桌面应用程序");
  178. alert.showAndWait();
  179. }
  180. private void showCloseConfirmation(Stage stage) {
  181. Alert alert = new Alert(Alert.AlertType.CONFIRMATION);
  182. alert.setTitle("确认关闭");
  183. alert.setHeaderText("您确定要关闭应用程序吗?");
  184. alert.setContentText("如果正在执行验证操作,关闭将中断该过程。");
  185. Optional<ButtonType> result = alert.showAndWait();
  186. if (result.isPresent() && result.get() == ButtonType.OK) {
  187. stage.close();
  188. }
  189. }
  190. private void chooseFile() {
  191. FileChooser fileChooser = new FileChooser();
  192. fileChooser.setTitle("选择文件");
  193. // 添加文件过滤器,只允许选择xlsx文件
  194. FileChooser.ExtensionFilter extFilter = new FileChooser.ExtensionFilter(
  195. "Excel文件 (*.xlsx)", "*.xlsx");
  196. fileChooser.getExtensionFilters().add(extFilter);
  197. File selectedFile = fileChooser.showOpenDialog(null);
  198. if (selectedFile != null) {
  199. fileField.setText(selectedFile.getAbsolutePath());
  200. }
  201. }
  202. private void chooseFolder() {
  203. DirectoryChooser directoryChooser = new DirectoryChooser();
  204. directoryChooser.setTitle("选择文件夹");
  205. File selectedFolder = directoryChooser.showDialog(null);
  206. if (selectedFolder != null) {
  207. folderField.setText(selectedFolder.getAbsolutePath());
  208. }
  209. }
  210. /**
  211. * 更新进度条和进度标签
  212. * @param message 进度消息
  213. * @param progress 进度值 (0.0 - 1.0)
  214. */
  215. private void updateProgress(String message, double progress) {
  216. javafx.application.Platform.runLater(() -> {
  217. progressLabel.setText(message);
  218. progressBar.setProgress(progress);
  219. });
  220. }
  221. private void startVerification() {
  222. String filePath = fileField.getText();
  223. String folderPath = folderField.getText();
  224. System.out.println("filePath = " + filePath);
  225. System.out.println(folderPath);
  226. if (filePath.isEmpty() || folderPath.isEmpty()) {
  227. Alert alert = new Alert(Alert.AlertType.ERROR);
  228. alert.setHeaderText("请选择文件和文件夹");
  229. alert.showAndWait();
  230. return;
  231. }
  232. // 初始化进度条
  233. progressBar.setProgress(0);
  234. progressBar.setVisible(true);
  235. progressLabel.setVisible(true);
  236. updateProgress("准备开始验证...", 0);
  237. inputModelList = new ArrayList<>();
  238. outputModelList = new ArrayList<>();
  239. pdfFileMap = new HashMap<>();
  240. List<String> errorImeiList = new ArrayList<>();
  241. // 读取excel
  242. updateProgress("正在读取Excel文件...", 0.1);
  243. EasyExcel.read(filePath, InputModel.class, new PageReadListener<InputModel>(dataList -> {
  244. for (InputModel inputModel : dataList) {
  245. inputModelList.add(inputModel);
  246. }
  247. })).sheet().doRead();
  248. updateProgress("Excel文件读取完成,正在扫描文件夹...", 0.25);
  249. //读取文件夹
  250. File folder = new File(folderPath);
  251. File[] files = folder.listFiles();
  252. // 扫描文件夹并建立IMEI-PDF映射
  253. int totalFolders = files.length;
  254. int processedFolders = 0;
  255. for (File file : files) {
  256. if (file.isFile()) {
  257. continue;
  258. }
  259. File[] listFiles = file.listFiles();
  260. String imei = file.getName().split("-")[2];
  261. //拿到文件夹里的pdf
  262. for (File pdfFile : listFiles) {
  263. if (pdfFile.getName().endsWith(".pdf")) {
  264. if (pdfFileMap.containsKey(imei)) {
  265. //出现重复的imei
  266. Alert alert = new Alert(Alert.AlertType.ERROR);
  267. alert.setHeaderText("出现重复的imei");
  268. alert.setContentText("请检查文件夹中是否出现重复的imei:" + imei);
  269. alert.showAndWait();
  270. return;
  271. }
  272. pdfFileMap.put(imei, pdfFile);
  273. break;
  274. }
  275. }
  276. processedFolders++;
  277. double progress = 0.25 + (0.25 * processedFolders / totalFolders);
  278. updateProgress("正在扫描文件夹: " + processedFolders + "/" + totalFolders, progress);
  279. }
  280. updateProgress("文件夹扫描完成,开始解析PDF文件...", 0.5);
  281. // 解析PDF文件
  282. int totalPDFs = inputModelList.size();
  283. int processedPDFs = 0;
  284. for (InputModel inputModel : inputModelList) {
  285. OutputModel outputModel = new OutputModel(inputModel);
  286. String imei = inputModel.getImei();
  287. //找到对应pdf的文件路径
  288. File pdfFile = pdfFileMap.getOrDefault(imei, null);
  289. if (Objects.isNull(pdfFile)) {
  290. errorImeiList.add(imei);
  291. processedPDFs++;
  292. double progress = 0.5 + (0.4 * processedPDFs / totalPDFs);
  293. updateProgress("解析PDF文件: " + processedPDFs + "/" + totalPDFs + " (IMEI未找到: " + imei + ")", progress);
  294. continue;
  295. }
  296. //解析pdf
  297. String text = "";
  298. try (PDDocument pdDocument = Loader.loadPDF(pdfFile)) {
  299. PDFTextStripper textStripper = new PDFTextStripper();
  300. //提取文本
  301. text = textStripper.getText(pdDocument);
  302. //解析金额
  303. Matcher matcher = pattern.matcher(text);
  304. if (matcher.find()) {
  305. String money = matcher.group("money"); // 获取命名分组 "money"
  306. //System.out.println("金额: " + money); // 输出: 金额
  307. BigDecimal amount1 = new BigDecimal(inputModel.getAmount());
  308. BigDecimal amount2 = new BigDecimal(money);
  309. outputModel.setPdfAmount(amount2.doubleValue());
  310. outputModel.setMargin(amount1.subtract(amount2).doubleValue());
  311. } else {
  312. System.out.println("未匹配到金额");
  313. errorImeiList.add(imei);
  314. }
  315. } catch (IOException | NumberFormatException e) {
  316. e.printStackTrace();
  317. errorImeiList.add(imei);
  318. }
  319. outputModelList.add(outputModel);
  320. processedPDFs++;
  321. double progress = 0.5 + (0.4 * processedPDFs / totalPDFs);
  322. updateProgress("解析PDF文件: " + processedPDFs + "/" + totalPDFs, progress);
  323. }
  324. updateProgress("PDF文件解析完成,正在生成输出文件...", 0.9);
  325. //输出最终文件
  326. String outputFileName = filePath.substring(0, filePath.lastIndexOf(".")) + "_" + System.currentTimeMillis() + "_output.xlsx";
  327. EasyExcel.write(outputFileName, OutputModel.class).sheet("模板").doWrite(outputModelList);
  328. updateProgress("验证完成!输出文件: " + outputFileName, 1.0);
  329. // 显示完成信息
  330. javafx.application.Platform.runLater(() -> {
  331. Alert alert = new Alert(Alert.AlertType.INFORMATION);
  332. alert.setTitle("验证完成");
  333. alert.setHeaderText("金额验证已完成");
  334. alert.setContentText("输出文件已生成: " + outputFileName +
  335. (errorImeiList.isEmpty() ? "" : "\n\n以下IMEI处理失败: " + String.join(", ", errorImeiList)));
  336. alert.showAndWait();
  337. // 隐藏进度条
  338. progressBar.setVisible(false);
  339. progressLabel.setVisible(false);
  340. });
  341. inputModelList = null;
  342. outputModelList = null;
  343. pdfFileMap = null;
  344. }
  345. }