Generate report in JAVA

1Тема от Dennis

28/01/2017 15:43:22Generate report in JAVA

Dennis
Gurtam Partner
Неактивен

Откуда: Netherlands
Зарегистрирован: 14/08/2012
Сообщений: 30
Продукты: Wialon Hosting
Карма: 14

Тема: Generate report in JAVA

We are creating a service that will send a report to the users using the JAVA SDK.
However I'm having trouble figuring out what to do exactly.

I'd like to generate a ride report for a user, and I understand how to get all the users under our account, but what now?

I realise I need to receive a report template using the searchItems method, so I'm doing this like this:

SearchSpec reportSearchSpec = new SearchSpec();
// get report templates
// Set items type to search avl_units
reportSearchSpec.setItemsType(Item.ItemType.avl_resource);

// Set sort type by units name
reportSearchSpec.setSortType("sys_name");

reportSearchSpec.setPropName("avl_resource");
reportSearchSpec.setPropValueMask("*");

session.searchItems(reportSearchSpec, 1, Resource.dataFlag.reports.getValue() , 0,
                                            Integer.MAX_VALUE, new SearchResponseHandler() {
                                                @Override
                                                public void onSuccessSearch(Item... reportTemplates) {
                                                    super.onSuccessSearch(reportTemplates);
                                                    
                                                    
                                                

                                                }

                                                @Override
                                                public void onFailure(int errorCode, Throwable throwableError) {
                                                    super.onFailure(errorCode, throwableError);
                                                    // search item failed, print error
                                                    System.out.println("error  " + Errors.getErrorText(errorCode));

                                                }
                                            });

This gives a lot of nullpointer exceptions for some reason.
Does anybody have an example of how to generate a report using the JAVA SDK?

I tried using the execReport function of the Report class but I have no idea what to put in the constructor and method parameters.

Thanks in advance!

Сайт Dennis Профиль

2Ответ от kopa

30/01/2017 09:59:04Generate report in JAVA

kopa
Gurtam Mobile Development
Неактивен

Откуда: Belarus
Зарегистрирован: 03/02/2011
Сообщений: 806
Продукты: Wialon Hosting Wialon Pro Wialon Kit Wialon Local flespi
Карма: 114

Re: Generate report in JAVA

Dennis пишет:

I realise I need to receive a report template using the searchItems method

This is the right way, just pay attention to the parameters:

        SearchSpec searchSpec=new SearchSpec();
        //Set items type to search avl_resource
        searchSpec.setItemsType(Item.ItemType.avl_resource);
        //Set property name to search
        searchSpec.setPropName("sys_name");
        //Set property value mask to search all resources
        searchSpec.setPropValueMask("*");
        //Set sort type by resource name
        searchSpec.setSortType("sys_name");

You have found the correct dataFlag, but you need to add it to the base item's dataFlag

        session.searchItems(searchSpec, 1, Item.dataFlag.base.getValue() | Resource.dataFlag.reports.getValue(), 0, Integer.MAX_VALUE, new SearchResponseHandler());

And after in the onSuccessSearch you will receive all your resources. To get report templates you need to call resource.getReportPlugin()

            @Override
            public void onSuccessSearch(Item... items) {
                super.onSuccessSearch(items);
                // Search succeed
                System.out.println("Search items is successful");
                if (items!=null && items.length>0) {
                    for (Item item : items){
                        if (item instanceof Resource)
                           System.out.println(String.format("\t%s",((Resource)item).getReportPlugin().getProperties().toString()));
                    }
               }
            }

To execute the report and get tables and other report's data you can look at Remote API sample.
Unfortunately Java SDK does not contain all of the methods for easy work with reports, but sources is available on GitHub, and you can modify it for your purposes, or make something like JavaScript SDK ReportResult (example of usage).

Mobile Development
Gurtam

Профиль

3Ответ от Dennis

31/01/2017 22:18:21Generate report in JAVA

Dennis
Gurtam Partner
Неактивен

Откуда: Netherlands
Зарегистрирован: 14/08/2012
Сообщений: 30
Продукты: Wialon Hosting
Карма: 14

Re: Generate report in JAVA

Thank you, this helps a lot!

Сайт Dennis Профиль

4Ответ от Dennis

01/02/2017 21:34:15Generate report in JAVA

Dennis
Gurtam Partner
Неактивен

Откуда: Netherlands
Зарегистрирован: 14/08/2012
Сообщений: 30
Продукты: Wialon Hosting
Карма: 14

Re: Generate report in JAVA

One more question, I can't find the get_result_rows
https://sdk.wialon.com/wiki/en/sidebar/ … esult_rows
in the SDK. Is this not available or is it not inside the report object?

Сайт Dennis Профиль

5Ответ от kopa

02/02/2017 09:49:51Generate report in JAVA

kopa
Gurtam Mobile Development
Неактивен

Откуда: Belarus
Зарегистрирован: 03/02/2011
Сообщений: 806
Продукты: Wialon Hosting Wialon Pro Wialon Kit Wialon Local flespi
Карма: 114

Re: Generate report in JAVA

Dennis it's not available at Java SDK, but you can implement it by yourself, and make a pull request on GitHub

Mobile Development
Gurtam

Профиль

6Ответ от Dennis

03/02/2017 12:56:32Generate report in JAVA

Dennis
Gurtam Partner
Неактивен

Откуда: Netherlands
Зарегистрирован: 14/08/2012
Сообщений: 30
Продукты: Wialon Hosting
Карма: 14

Re: Generate report in JAVA

Ok, no problem, but our programmer can't create a pull request,(button is grayed out) do we need to be authorized?

Сайт Dennis Профиль

7Ответ от kopa

06/02/2017 10:00:44Generate report in JAVA

kopa
Gurtam Mobile Development
Неактивен

Откуда: Belarus
Зарегистрирован: 03/02/2011
Сообщений: 806
Продукты: Wialon Hosting Wialon Pro Wialon Kit Wialon Local flespi
Карма: 114

Re: Generate report in JAVA

Dennis I think yes. You can find more information at GitHub Help.

Mobile Development
Gurtam

Профиль

8Ответ от Dennis

21/03/2017 23:10:02Generate report in JAVA

(21/03/2017 23:13:15 отредактировано Dennis)

Dennis
Gurtam Partner
Неактивен

Откуда: Netherlands
Зарегистрирован: 14/08/2012
Сообщений: 30
Продукты: Wialon Hosting
Карма: 14

Re: Generate report in JAVA

I have one more question, the report templates I receive from get_result_rows are all grouped by date, is it possible to get the report details like in the webportal when we click detailed?
Or do we have to create a new report for that?

Сайт Dennis Профиль

9Ответ от deal

22/03/2017 14:08:17Generate report in JAVA

deal
Wialon fan club
Неактивен

Откуда: Минск
Зарегистрирован: 01/02/2011
Сообщений: 592
Продукты: Wialon Hosting Wialon Pro Wialon Local
Карма: 149

Re: Generate report in JAVA

Dennis, you can use report/select_result_rows request with this parameters:
to get all collapsed rows: params={"tableIndex":0,"config":{"type":"range","data":{"from":0,"to":0,"level":0}}}
to get all subrows of some row(s): params={"tableIndex":0,"config":{"type":"row","data":{"rows":["0"],"level":0}}}

Head of Wialon Local Department
Gurtam

Профиль

10Ответ от supriyala