Skip to Content
This question has been flagged
quotereportingsale.order
2 Replies
8300 Views
Avatar
simmeringc

Is there some kind of endpoint or get protocol to download a quotation_order printout report without having to use the Odoo GUI?

Thanks

Avatar
Discard
Avatar
simmeringc
Author Best Answer

Here's my method for generating quotation_order pdf's with Java if anyone finds this in the future:


private void generateOrderReport(final Object internalOdooQuoteId) throws XmlRpcException, IOException {
    logger.info("generating quote report pdf for order #: " + internalOdooQuoteId);
    final Object internalOdooQuoteIds = asList((Object[]) models.execute("execute_kw", asList(
      db, uid, password,
      "sale.order", "search",
      asList(asList(
        asList("id", "=", internalOdooQuoteId)
      )),
      new HashMap() {{
        put("limit", 1);
      }}
    )));
    final XmlRpcClientConfigImpl report_config = new XmlRpcClientConfigImpl();
    report_config.setServerURL(
      new URL(String.format("%s/xmlrpc/2/report", url)));
    final Map<String, Object> result = (Map<String, Object>)models.execute(
      report_config, "render_report", asList(
        db, uid, password,
        "sale.report_saleorder",
        internalOdooQuoteIds));
    final byte[] report_data = DatatypeConverter.parseBase64Binary(
      (String)result.get("result"));
    File file = new File("records/quotation_order.pdf");
    FileUtils.writeByteArrayToFile(file, report_data);
  }
Avatar
Discard
Niyas Raphy (Walnut Software Solutions)

If you are looking to get the report of a sale, suppose you have to print the Quotation/Order of the sales having the id is 5, then you can get the report from the url as follows :- 0.0.0.0:8014/report/pdf/sale.report_sale_order/5

simmeringc
Author

Do you know how I could do this with the Java example from the docs? sale.report_sale_order doesn't seem to be a model:

final Object[] reportIds = (Object[])models.execute(

"execute_kw", asList(

db, uid, password,

"sale.order", "search",

asList(asList(

))

));

System.out.println(reportIds);

final XmlRpcClientConfigImpl report_config = new XmlRpcClientConfigImpl();

report_config.setServerURL(

new URL(String.format("%s/xmlrpc/2/report", url)));

final Map<String, Object> result = (Map<String, Object>)models.execute(

report_config, "render_report", asList(

db, uid, password,

"sale.report_sale_order",

reportIds));

final byte[] report_data = DatatypeConverter.parseBase64Binary(

(String)result.get("result"));

File file = new File("proposal/odooOutput.pdf");

byte[] bytes = Base64.decodeBase64(report_data);

FileUtils.writeByteArrayToFile(file, report_data);

Niyas Raphy (Walnut Software Solutions)

Try this : 0.0.0.0:8014/report/pdf/sale.report_saleorder/5

Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

To get the reports from the code without going to the user interface you can check this, after authenticating you can choose any of this methods explained in it :

https://www.odoo.com/forum/help-1/question/how-to-print-report-from-website-121485

Suppose if you have to print the Quotation/Order in the sale order having the id 5, then from url you can get the report like this : http://0.0.0.0:8014/report/pdf/sale.report_saleorder/5

Thanks

Avatar
Discard
Related Posts Replies Views Activity
Have the percentage of sale orders / quote : percentage of quote that became a sale orders per user
quote sale.order
Avatar
1
जुल॰ 16
2784
Quote list showing products
product quote reporting
Avatar
Avatar
1
दिस॰ 24
1362
Odoo v 12 Sequence for Quote and Sale order Solved
quote sale.order sequences v12
Avatar
Avatar
1
फ़र॰ 19
6935
Product label with QR code
reporting
Avatar
Avatar
1
नव॰ 25
114
Display field only for one company on list view Solved
sale.order
Avatar
Avatar
1
मई 25
1827