Support for custom reports

[alensiljak]

Similar to desktop application, users want to be able to create and use custom reports.

The display is HTML so a webView can be used to render reports.
Export option might also be handy.

[alensiljak]

Initial implementation could be just the viewer for the already created reports. The reports are found in the Report_v1 table.
Template is the HTML content and the SQL is in SQLContent field.

[velmuruganc]

@mistery , I use custom report very frequently and will pick this up after moving sms transaction feature to stable release.

[velmuruganc]

@mistery, could you please tell me where i can add values like this "R.id.menu_reports". I want to use as "R.id.menu_custom_reports", but throws error "Error:(1065, 55) error: cannot find symbol variable menu_custom_reports"

[alensiljak]

You should check strings.xml.

[velmuruganc]

@mistery , thanks i got. Also I have completed the UI changes. Now learning the fragments to implement the report activity.

[alensiljak]

You can have a look at a web browser activity/fragment. I think it is used a few places in the app already, like the intro or donations page. I think it would be the best to have an HTML output from custom reports and display it in a web browser activity.

[velmuruganc]

@mistery, What is the use of adapters. Could you please give some idea in this?

[alensiljak]

Hi,
I would recommend reading (a lot) about any unclear parts of the code. Specifically:

• https://developer.android.com/reference/android/widget/Adapter.html
• https://www.intertech.com/Blog/android-adapters-adapterviews/
• https://code.tutsplus.com/tutorials/android-from-scratch-understanding-adapters-and-adapter-views--cms-26646
  etc.

As we are not in a rush to get the features out, it would be more preferrable to have the quality and maintainable code instead. That way other devs could easily jump in and modify the code in the future.
Also, please look at the existing code and try to follow any patterns set there. There is, of course, a lot of old code that should be updated with the changes in Java and Android but that is a fairly big task in itself.

You can try to use Google and Stack Overflow more to see the latest information regarding any Android concepts. Best of luck!

[velmuruganc]

@mistery, Thanks for the link. I will go thru these topics.

I don't think, we can use the web content for custom report, bcz i dont see any way to inject the data into html content available in report table.

[alensiljak]

What I had in mind is to use a templating engine. These, at least, are not in short supply:

• https://github.com/HubSpot/jinjava
• http://www.x5software.com/chunk/examples/ChunkExample
• http://www.vogella.com/tutorials/FreeMarker/article.html and https://freemarker.apache.org/
• http://www.vogella.com/tutorials/EclipseJET/article.html

If not, how else would you render custom reports to the user?

[velmuruganc]

@mistery, It would be straight fwd to fetch the result of sql query and show the row/clmns thru views & adapter. This would be similar to how we shows the payee and other reports. May be I am wrong. Let me learn and explore the possible options.

[alensiljak]

You may be right. I don't use custom reports so I don't really know what exactly is required.
My understanding was that the custom reports are alredy stored as HTML templates.

If you look at the second comment on this issue, you'll see what I mean.

[Spoker]

It would be great if custom reports worked the same as in the desktop version.
Don't forget that de sql output gets transformed through the lua script before being shown in the html. Also, some custom reports use javascript to show the results visually in a graph.

[alensiljak]

Yes, that is the original purpose of this request. Not to have just any report but to utilise the custom reports that are stored within the database file, matching the desktop functionality as much as is possible with a mobile device. With HTML, this should be possible to an extent.

[velmuruganc]

@mistery , App getting crashed when I call following line in my activity. It looks some issue with constructor. Could you please help me?

CustomReportAdapter reportAdapter = new CustomReportAdapter(this, getCustomReportCursor());

Following is the constructor in CustomReportAdapter,

public CustomReportAdapter(Context context, Cursor cursor) {
super(context, cursor, false);
}

[alensiljak]

Can you at least tell me what the error is? I can not tell what the issue is just by looking at this code.

[velmuruganc]

@Spoker, As of now, I could able to generate my own html page as a first step. Do you have any docs that explains how we should inject the sql output to html template?

[alensiljak]

Please look into some of the libraries I shared earlier. Preferably Jinja, as it will fit into some other work that is going on in parallel.

[velmuruganc]

One question. Do we need to call this as custom report or general report? Desktop version ref as general Report.

[alensiljak]

Hm, it used to be custom reports at a time when this request was created. :)
I have not been following closely. The name "general reports" makes no sense to me, to be honest.
These are user-generated reports or custom reports and the name should indicate their purpose.
However, if that is the name in the desktop version, then so be it.

[github-actions]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 5 days.

[github-actions]

This issue was closed because it has been stalled for 5 days with no activity.

[luisdev]

This would still be a good feature, so I think it should stay open.