Elasticsearch query with date range, company id and tracker id filter

query.json

{
   "sort": [
      {
         "_script": {
            "type": "number",
            "script": {
               "lang": "painless",
               "inline": "def date = LocalDateTime.ofInstant(Instant.ofEpochMilli(doc.start_date_time.value), ZoneId.of(\"+01:00\")); return Integer.parseInt(date.format(DateTimeFormatter.ofPattern(\"yyyyMMdd\")))"
            },
            "order": "asc"
         }
      },
      {
         "tracker_uid": "asc"
      },
      {
         "_script": {
            "type": "number",
            "script": {
               "lang": "painless",
               "inline": "LocalDateTime.ofInstant(Instant.ofEpochMilli(doc.start_date_time.value), ZoneId.of(\"+01:00\")).toEpochSecond(ZoneOffset.UTC)"
            },
            "order": "asc"
         }
      }
   ],
   "from": 0,
   "size": 100,
   "query": {
      "bool": {
         "filter": {
            "bool": {
               "must": [
                  {
                     "range": {
                        "start_date_time": {
                           "gte": "2017-05-31 00:00:00",
                           "lte": "2017-05-31 23:59:59",
                           "time_zone": "+01:00"
                        }
                     }
                  },
                  {
                     "range": {
                        "journey_time_secs": {
                           "gte": 60
                        }
                     }
                  },
                  {
                     "term": {
                        "tracker_id": "868204007016313"
                     }
                  }
               ]
            }
         },
         "must": {
            "match": {
               "company_id": 27283
            }
         }
      }
   },
   "aggs": {
      "total_idling_time": {
         "sum": {
            "field": "idling_time_secs"
         }
      },
      "total_journey_time": {
         "sum": {
            "field": "journey_time_secs"
         }
      },
      "total_distance": {
         "sum": {
            "field": "distance_km"
         }
      }
   }
}