Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package account.management.controller; import account.management.model.AutoCompleteComboBoxListener; import account.management.model.BS; import account.management.model.CNF; import account.management.model.MetaData; import com.mashape.unirest.http.HttpResponse; import com.mashape.unirest.http.JsonNode; import com.mashape.unirest.http.Unirest; import com.mashape.unirest.http.exceptions.UnirestException; import java.net.URL; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.HashMap; import java.util.List; import java.util.ResourceBundle; import java.util.Vector; import java.util.logging.Level; import java.util.logging.Logger; import javafx.collections.FXCollections; import javafx.event.ActionEvent; import javafx.fxml.FXML; import javafx.fxml.Initializable; import javafx.scene.control.Button; import javafx.scene.control.ComboBox; import javafx.scene.control.DatePicker; import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource; import org.json.JSONArray; import org.json.JSONObject; import report.Report; /** * FXML Controller class * * @author mohar */ public class CNFReportController implements Initializable { @FXML private ComboBox<CNF> select_cnf; @FXML private DatePicker start; @FXML private DatePicker end; @FXML private Button show; @FXML private Button cancel; private List<CNF> cnf; /** * Initializes the controller class. */ @Override public void initialize(URL url, ResourceBundle rb) { new AutoCompleteComboBoxListener<>(select_cnf); select_cnf.setOnHiding((e) -> { CNF a = select_cnf.getSelectionModel().getSelectedItem(); select_cnf.setEditable(false); select_cnf.getSelectionModel().select(a); }); select_cnf.setOnShowing((e) -> { select_cnf.setEditable(true); }); cnf = FXCollections.observableArrayList(); new Thread(() -> { try { HttpResponse<JsonNode> res = Unirest.get(MetaData.baseUrl + "get/cnf/all").asJson(); JSONArray array = res.getBody().getArray(); for (int i = 0; i < array.length(); i++) { JSONObject obj = array.getJSONObject(i); long id = obj.getLong("id"); String name = obj.getString("party_name"); String address = obj.getString("party_address"); cnf.add(new CNF(String.valueOf(id), name, address)); } } catch (UnirestException ex) { Logger.getLogger(LCReportController.class.getName()).log(Level.SEVERE, null, ex); } finally { this.select_cnf.getItems().addAll(cnf); } }).start(); } @FXML private void onShowReportButtonClick(ActionEvent event) { String start_date, end_date; try { String lc_id = this.select_cnf.getSelectionModel().getSelectedItem().getId(); start_date = new SimpleDateFormat("yyyy-MM-dd") .format(new SimpleDateFormat("yyyy-MM-dd").parse(this.start.getValue().toString())); end_date = new SimpleDateFormat("yyyy-MM-dd") .format(new SimpleDateFormat("yyyy-MM-dd").parse(this.end.getValue().toString())); HttpResponse<JsonNode> res = Unirest.get(MetaData.baseUrl + "report/balancesheet") .queryString("date", "\"" + start_date + "\"").queryString("plc", lc_id).asJson(); HttpResponse<JsonNode> res2 = Unirest.get(MetaData.baseUrl + "report/balancesheet") .queryString("date", "\"" + end_date + "\"").queryString("plc", lc_id).asJson(); JSONArray bs = res.getBody().getArray(); JSONArray bs2 = res2.getBody().getArray(); System.out.println(bs); System.out.println(bs2); HashMap params = new HashMap(); Vector v = new Vector(); float total_non_current_asset = 0, total_current_asset = 0, total_revenue = 0, total_expense = 0; for (int i = 0; i < bs.length(); i++) { JSONObject obj = bs.getJSONObject(i); JSONObject obj2 = bs2.getJSONObject(i); String id = obj.get("id").toString(); String balance = String.valueOf(Float.parseFloat(obj2.get("totalBalance").toString()) - Float.parseFloat(obj.get("totalBalance").toString())); v.add(new BS(id, balance)); params.put(id, balance); // total non current asset if (Integer.parseInt(id) >= 9 && Integer.parseInt(id) <= 12) { total_non_current_asset += Float.parseFloat(balance); } // total current asset if (Integer.parseInt(id) >= 13 && Integer.parseInt(id) <= 27) { total_current_asset += Float.parseFloat(balance); } // total revenue if (Integer.parseInt(id) >= 38 && Integer.parseInt(id) <= 40) { total_revenue += Float.parseFloat(balance); } // total expense if ((Integer.parseInt(id) >= 42 && Integer.parseInt(id) <= 44) || (Integer.parseInt(id) >= 46 && Integer.parseInt(id) <= 48) || (Integer.parseInt(id) >= 50 && Integer.parseInt(id) <= 57)) { total_expense += Float.parseFloat(balance); } } params.put("date", new SimpleDateFormat("dd-MM-yyyy") .format(new SimpleDateFormat("yyyy-MM-dd").parse(this.start.getValue().toString())) + "To " + new SimpleDateFormat("dd-MM-yyyy").format( new SimpleDateFormat("yyyy-MM-dd").parse(this.end.getValue().toString()))); params.put("total_non_current_asset", String.valueOf(total_non_current_asset)); params.put("total_current_asset", String.valueOf(total_current_asset)); params.put("total_revenue", String.valueOf(total_revenue)); params.put("total_expense", String.valueOf(total_expense)); params.put("net_profit", String.valueOf(total_revenue - total_expense)); CNF c = this.select_cnf.getSelectionModel().getSelectedItem(); params.put("party_name", "Party Name: " + c.getParty_name()); params.put("party_address", "Party Address: " + c.getParty_address()); Report r = new Report(); r.getReport("src\\report\\CNF.jrxml", new JRBeanCollectionDataSource(v), params, "CNF Report"); } catch (ParseException ex) { Logger.getLogger(LCReportController.class.getName()).log(Level.SEVERE, null, ex); } catch (UnirestException ex) { Logger.getLogger(LCReportController.class.getName()).log(Level.SEVERE, null, ex); } } @FXML private void onCancelButtonClick(ActionEvent event) { this.cancel.getScene().getWindow().hide(); } }