1

DateTime (parsed) comes wrong in to a report Remote API (PHP)

(edited by cerpas 02/10/2018 00:29:03)

Topic: DateTime (parsed) comes wrong in to a report Remote API (PHP)

Hello me again.

My problem is the response of your sdk in a report (Eco driving) when this report is grouping by date. I tried send the same request same params but the response is diferent you can show this case netx:

I execute the report from the dates 2018-09-25 00:00: to 2018-09-26 23:59:59

In wialon hosting response:

[
  {
    "n": 0,
    "i1": 0,
    "i2": 1568,
    "t1": 1537826459,
    "t2": 1537912992,
    "d": 4,
    "c": [
      "1",
      "2018-09-25",
      "166.96 km",
      "",
      "3",
      ""
    ]
  },
  {
    "n": 1,
    "i1": 1568,
    "i2": 2954,
    "t1": 1537912992,
    "t2": 1537999193,
    "d": 3,
    "c": [
      "2",
      "2018-09-26",
      "88.08 km",
      "",
      "2",
      ""
    ]
  }
]

The sdk response

[
    {
      "n": 0,
      "i1": 0,
      "i2": 159,
      "t1": 1537826459,
      "t2": 1537832158,
      "d": 1,
      "c": [
        "2018-09-24",
        "29.65 km",
        "",
        "0",
        ""
      ],
    },
    {
      "n": 1,
      "i1": 170,
      "i2": 1641,
      "t1": 1537835070,
      "t2": 1537914805,
      "d": 4,
      "c": [
        "2018-09-25",
        "144.60 km",
        "",
        "4",
        ""
      ]
    },
    {
      "n": 2,
      "i1": 1816,
      "i2": 2954,
      "t1": 1537972726,
      "t2": 1537999193,
      "d": 2,
      "c": [
        "2018-09-26",
        "80.78 km",
        "",
        "1",
        ""
      ],
     
    }
  ]
]

I use de remote API (PHP in utc=0) but if i change this time zone not afect the result. Besides my apps normally works in a multiple timezones,but in this especific case I need fix this problem.

This issue occurs me in any report execution.

If you sum the total mileage this are equals but, for this reason the problem is the grouping by date .

I hope you can help me to fix this beacuse I need the daily mileage .

Best Regards

2

DateTime (parsed) comes wrong in to a report Remote API (PHP)

Re: DateTime (parsed) comes wrong in to a report Remote API (PHP)

Hey

You have to set_locale before execute report
Check topic https://forum.gurtam.com/viewtopic.php? … 86#p124086

3

DateTime (parsed) comes wrong in to a report Remote API (PHP)

Re: DateTime (parsed) comes wrong in to a report Remote API (PHP)

Dear shmi

Thanks a lot, you saved us.