account.management.controller.ReportTrialBalanceController.java Source code

Introduction

Here is the source code for account.management.controller.ReportTrialBalanceController.java

Source

/*
 * 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.MetaData;
import account.management.model.TrialBalance;
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.util.HashMap;
import java.util.ResourceBundle;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.fxml.Initializable;
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 ReportTrialBalanceController implements Initializable {
    @FXML
    private DatePicker start;
    @FXML
    private DatePicker end;

    /**
     * Initializes the controller class.
     */
    @Override
    public void initialize(URL url, ResourceBundle rb) {
        // TODO
    }

    @FXML
    private void onClickShowTrialBalance(ActionEvent event) {
        try {
            HttpResponse<JsonNode> res = Unirest.get(MetaData.baseUrl + "report/trialbalance/with/date")
                    .queryString("start_date", this.start.getValue().toString())
                    .queryString("end_date", this.end.getValue().toString()).asJson();
            JSONArray array = res.getBody().getArray();
            Vector v = new Vector();
            HashMap params = new HashMap();
            float total_dr = 0, total_cr = 0;
            for (int i = 1; i < array.length(); i++) {
                JSONObject obj = array.getJSONObject(i);
                String id = obj.get("id").toString();
                String name = obj.getString("name");
                String balance = String.format("%1$.2f", obj.getDouble("balance"));
                //String balance = String.valueOf(obj.getDouble("balance"));
                String dr, cr;
                if (Float.parseFloat(balance) < 0) {
                    cr = balance;
                    dr = "";
                    total_cr += Float.parseFloat(cr);
                } else {
                    dr = balance;
                    total_dr += Float.parseFloat(dr);
                    cr = "";
                }
                if (!dr.equals(""))
                    dr = String.format("%1$.2f", Double.parseDouble(dr));
                if (!cr.equals(""))
                    cr = String.format("%1$.2f", Double.parseDouble(cr));
                v.add(new TrialBalance(name, dr, cr));
            }

            Vector trialBalanceVector = getSortedTrialBalance(v, array);

            params.put("total_dr", String.format("%1$.2f", total_dr));
            params.put("total_cr", String.format("%1$.2f", total_cr * (-1)));
            Report report = new Report();
            report.getReport("src\\report\\trialBalance.jrxml", new JRBeanCollectionDataSource(trialBalanceVector),
                    params, "Trial Balance");

        } catch (UnirestException ex) {
            Logger.getLogger(ReportTrialBalanceController.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    public Vector getSortedTrialBalance(Vector in, JSONArray arrayIn) {

        Vector out = new Vector();
        try {
            HttpResponse<JsonNode> res = Unirest.get(MetaData.baseUrl + "trialbalance/sorted").asJson();
            JSONArray array = res.getBody().getArray();
            System.out.println(array);
            for (int i = 0; i < array.length(); i++) {
                out.add(getBalanace(array.get(i).toString(), arrayIn));
            }

        } catch (Exception e) {
        } finally {
            return out;
        }

    }

    public TrialBalance getBalanace(String id, JSONArray arrayIn) {
        for (int i = 0; i < arrayIn.length(); i++) {
            JSONObject obj = arrayIn.getJSONObject(i);
            if (obj.get("id").toString().equals(id)) {
                String name = obj.getString("name");

                String balance = String.format("%1$.2f", obj.getDouble("balance"));
                ;
                String dr, cr;
                if (Float.parseFloat(balance) < 0) {
                    cr = String.valueOf(Float.parseFloat(balance) * (-1));
                    dr = "";
                } else {
                    dr = balance;
                    cr = "";
                }
                return new TrialBalance(name, dr, cr);
            }
        }
        return null;
    }

}