Esempio n. 1
0
  public static void addUserAccounts(Invoice invoice, Document doc, Element parent) {

    Element userAccounts = doc.createElement("userAccounts");
    parent.appendChild(userAccounts);
    BillingAccount billingAccount = invoice.getBillingAccount();

    for (UserAccount userAccount : billingAccount.getUsersAccounts()) {
      Element userAccountTag = doc.createElement("userAccount");
      userAccountTag.setAttribute("id", userAccount.getId() + "");
      userAccountTag.setAttribute(
          "code", userAccount.getCode() != null ? userAccount.getCode() : "");
      userAccountTag.setAttribute(
          "description", userAccount.getDescription() != null ? userAccount.getDescription() : "");
      userAccounts.appendChild(userAccountTag);
      addNameAndAdress(userAccount, doc, userAccountTag);
      addCategories(userAccount, invoice, doc, userAccountTag, true);
    }
  }
Esempio n. 2
0
  public void createXMLInvoice(Invoice invoice, File billingRundir) throws BusinessException {
    try {
      boolean entreprise = invoice.getProvider().isEntreprise();

      DocumentBuilderFactory dbfac = DocumentBuilderFactory.newInstance();
      DocumentBuilder docBuilder = dbfac.newDocumentBuilder();
      Document doc = docBuilder.newDocument();

      Element invoiceTag = doc.createElement("invoice");
      Element header = doc.createElement("header");
      invoiceTag.setAttribute("number", "XXXXXXX");
      invoiceTag.setAttribute("id", invoice.getId().toString());
      invoiceTag.setAttribute(
          "customerId",
          invoice.getBillingAccount().getCustomerAccount().getCustomer().getCode() + "");
      invoiceTag.setAttribute(
          "customerAccountCode",
          invoice.getBillingAccount().getCustomerAccount().getCode() != null
              ? invoice.getBillingAccount().getCustomerAccount().getCode()
              : "");
      BillingCycle billingCycle = invoice.getBillingRun().getBillingCycle();
      invoiceTag.setAttribute(
          "templateName",
          billingCycle != null && billingCycle.getBillingTemplateName() != null
              ? billingCycle.getBillingTemplateName()
              : "default");
      doc.appendChild(invoiceTag);
      invoiceTag.appendChild(header);

      Customer customer = invoice.getBillingAccount().getCustomerAccount().getCustomer();
      Element customerTag = doc.createElement("customer");
      customerTag.setAttribute("id", customer.getId() + "");
      customerTag.setAttribute("code", customer.getCode() + "");
      customerTag.setAttribute(
          "externalRef1", customer.getExternalRef1() != null ? customer.getExternalRef1() : "");
      customerTag.setAttribute(
          "externalRef2", customer.getExternalRef2() != null ? customer.getExternalRef2() : "");
      header.appendChild(customerTag);
      addNameAndAdress(customer, doc, customerTag);

      CustomerAccount customerAccount = invoice.getBillingAccount().getCustomerAccount();
      Element customerAccountTag = doc.createElement("customerAccount");
      customerAccountTag.setAttribute("id", customerAccount.getId() + "");
      customerAccountTag.setAttribute("code", customerAccount.getCode() + "");
      customerAccountTag.setAttribute("description", customerAccount.getDescription() + "");
      customerAccountTag.setAttribute(
          "externalRef1",
          customerAccount.getExternalRef1() != null ? customerAccount.getExternalRef1() : "");
      customerAccountTag.setAttribute(
          "externalRef2",
          customerAccount.getExternalRef2() != null ? customerAccount.getExternalRef2() : "");

      EntityManager em = MeveoPersistence.getEntityManager();
      Query billingQuery =
          em.createQuery(
              "select si from ServiceInstance si join si.subscription s join s.userAccount ua join ua.billingAccount ba join ba.customerAccount ca where ca.id = :customerAccountId");
      billingQuery.setParameter("customerAccountId", customerAccount.getId());
      List<ServiceInstance> services = (List<ServiceInstance>) billingQuery.getResultList();
      boolean terminated = isAllServiceInstancesTerminated(services);

      customerAccountTag.setAttribute("accountTerminated", terminated + "");

      header.appendChild(customerAccountTag);
      addNameAndAdress(customerAccount, doc, customerAccountTag);
      addproviderContact(customerAccount, doc, customerAccountTag);

      BillingAccount billingAccount = invoice.getBillingAccount();
      Element billingAccountTag = doc.createElement("billingAccount");
      if (billingCycle == null) {
        billingCycle = billingAccount.getBillingCycle();
      }
      String billingCycleCode = billingCycle != null ? billingCycle.getCode() + "" : "";
      billingAccountTag.setAttribute("billingCycleCode", billingCycleCode);
      String billingAccountId = billingAccount.getId() + "";
      String billingAccountCode = billingAccount.getCode() + "";
      billingAccountTag.setAttribute("id", billingAccountId);
      billingAccountTag.setAttribute("code", billingAccountCode);
      billingAccountTag.setAttribute("description", billingAccount.getDescription() + "");
      billingAccountTag.setAttribute(
          "externalRef1",
          billingAccount.getExternalRef1() != null ? billingAccount.getExternalRef1() : "");
      billingAccountTag.setAttribute(
          "externalRef2",
          billingAccount.getExternalRef2() != null ? billingAccount.getExternalRef2() : "");
      header.appendChild(billingAccountTag);

      if (billingAccount.getName() != null && billingAccount.getName().getTitle() != null) {
        Element company = doc.createElement("company");
        Text companyTxt =
            doc.createTextNode(billingAccount.getName().getTitle().getIsCompany() + "");
        billingAccountTag.appendChild(companyTxt);
      }

      Element email = doc.createElement("email");
      Text emailTxt =
          doc.createTextNode(billingAccount.getEmail() != null ? billingAccount.getEmail() : "");
      email.appendChild(emailTxt);
      billingAccountTag.appendChild(email);

      addNameAndAdress(billingAccount, doc, billingAccountTag);

      addPaymentInfo(billingAccount, doc, billingAccountTag);

      Element invoiceDate = doc.createElement("invoiceDate");
      Text invoiceDateTxt =
          doc.createTextNode(
              DateUtils.formatDateWithPattern(invoice.getInvoiceDate(), "dd/MM/yyyy"));
      invoiceDate.appendChild(invoiceDateTxt);
      header.appendChild(invoiceDate);

      Element dueDate = doc.createElement("dueDate");
      Text dueDateTxt =
          doc.createTextNode(DateUtils.formatDateWithPattern(invoice.getDueDate(), dueDateFormat));
      dueDate.appendChild(dueDateTxt);
      header.appendChild(dueDate);
      addHeaderCategories(invoice, doc, header);

      Element amount = doc.createElement("amount");
      invoiceTag.appendChild(amount);

      Element currency = doc.createElement("currency");
      Text currencyTxt = doc.createTextNode("EUR");
      currency.appendChild(currencyTxt);
      amount.appendChild(currency);

      Element amountWithoutTax = doc.createElement("amountWithoutTax");
      Text amountWithoutTaxTxt = doc.createTextNode(round(invoice.getAmountWithoutTax()));
      amountWithoutTax.appendChild(amountWithoutTaxTxt);
      amount.appendChild(amountWithoutTax);

      Element amountWithTax = doc.createElement("amountWithTax");
      Text amountWithTaxTxt = doc.createTextNode(round(invoice.getAmountWithTax()));
      amountWithTax.appendChild(amountWithTaxTxt);
      amount.appendChild(amountWithTax);

      BigDecimal balance =
          computeBalance(
              invoice.getBillingAccount().getCustomerAccount().getCode(), invoice.getDueDate());

      if (balance == null) {
        throw new BusinessException("account balance calculation failed");
      }
      BigDecimal netToPay = BigDecimal.ZERO;
      if (entreprise) {
        netToPay = invoice.getAmountWithTax();
      } else {
        netToPay = invoice.getAmountWithTax().add(balance);
      }

      Element balanceElement = doc.createElement("balance");
      Text balanceTxt = doc.createTextNode(round(balance));
      balanceElement.appendChild(balanceTxt);
      amount.appendChild(balanceElement);

      Element netToPayElement = doc.createElement("netToPay");
      Text netToPayTxt = doc.createTextNode(round(netToPay));
      netToPayElement.appendChild(netToPayTxt);
      amount.appendChild(netToPayElement);

      addTaxes(invoice, doc, amount);

      Element detail = doc.createElement("detail");
      invoiceTag.appendChild(detail);
      addUserAccounts(invoice, doc, detail);

      TransformerFactory transfac = TransformerFactory.newInstance();
      Transformer trans = transfac.newTransformer();
      trans.setOutputProperty(OutputKeys.OMIT_XML_DECLARATION, "yes");
      trans.setOutputProperty(OutputKeys.INDENT, "yes");

      // create string from xml tree
      DOMSource source = new DOMSource(doc);
      StreamResult result =
          new StreamResult(
              billingRundir + File.separator + invoice.getTemporaryInvoiceNumber() + ".xml");
      logger.info("source=" + source.toString());
      trans.transform(source, result);

    } catch (Exception e) {
      e.printStackTrace();
      throw new BusinessException(e.getMessage());
    }
  }
Esempio n. 3
0
  public static void addPaymentInfo(BillingAccount billingAccount, Document doc, Element parent) {

    Element paymentMethod = doc.createElement("paymentMethod");
    parent.appendChild(paymentMethod);
    paymentMethod.setAttribute("type", billingAccount.getPaymentMethod().toString());
    Element bankCoordinates = doc.createElement("bankCoordinates");
    Element bankCode = doc.createElement("bankCode");
    Element branchCode = doc.createElement("branchCode");
    Element accountNumber = doc.createElement("accountNumber");
    Element accountOwner = doc.createElement("accountOwner");
    Element key = doc.createElement("key");
    Element iban = doc.createElement("IBAN");
    bankCoordinates.appendChild(bankCode);
    bankCoordinates.appendChild(branchCode);
    bankCoordinates.appendChild(accountNumber);
    bankCoordinates.appendChild(accountOwner);
    bankCoordinates.appendChild(key);
    bankCoordinates.appendChild(iban);
    paymentMethod.appendChild(bankCoordinates);

    if (billingAccount.getBankCoordinates() != null
        && billingAccount.getBankCoordinates().getBankCode() != null) {
      Text bankCodeTxt =
          doc.createTextNode(
              billingAccount.getBankCoordinates().getBankCode() != null
                  ? billingAccount.getBankCoordinates().getBankCode()
                  : "");
      bankCode.appendChild(bankCodeTxt);

      Text branchCodeTxt =
          doc.createTextNode(
              billingAccount.getBankCoordinates().getBranchCode() != null
                  ? billingAccount.getBankCoordinates().getBranchCode()
                  : "");
      branchCode.appendChild(branchCodeTxt);

      Text accountNumberTxt =
          doc.createTextNode(
              billingAccount.getBankCoordinates().getAccountNumber() != null
                  ? billingAccount.getBankCoordinates().getAccountNumber()
                  : "");
      accountNumber.appendChild(accountNumberTxt);

      Text accountOwnerTxt =
          doc.createTextNode(
              billingAccount.getBankCoordinates().getAccountOwner() != null
                  ? billingAccount.getBankCoordinates().getAccountOwner()
                  : "");
      accountOwner.appendChild(accountOwnerTxt);

      Text keyTxt =
          doc.createTextNode(
              billingAccount.getBankCoordinates().getKey() != null
                  ? billingAccount.getBankCoordinates().getKey()
                  : "");
      key.appendChild(keyTxt);
      if (billingAccount.getBankCoordinates().getIban() != null) {
        Text ibanTxt =
            doc.createTextNode(
                billingAccount.getBankCoordinates().getIban() != null
                    ? billingAccount.getBankCoordinates().getIban()
                    : "");
        iban.appendChild(ibanTxt);
      }
    }
  }