invernyx / smartcars-3-bugs

The bug tracker for the smartCARS 3 application
3 stars 0 forks source link

[BUG] - Logbook Out of Order #371

Closed walkerairtrans closed 2 months ago

walkerairtrans commented 9 months ago

Describe the bug

Logbook appears out of order compared to it's JSON payload. Here's a JSON payload from the Logbook plugin. logbook.json

How do you reproduce this bug?

Compare the logbook to your flights

Expected behavior

Flights should be in order by date (newest at the top)

Screenshots

image

Operating system

Windows 11

Community airline

Walker Air Transport

smartCARS Version

3.1.1

Plugins installed

chat, map, flight center, flight tracker, logbook

Additional context

No response

GenericNerd commented 8 months ago

From what I can see in the screenshot provided, it seems like it is sorting correctly by the date, but not by the time. Can you confirm whether this is the case for you?

charmor38 commented 7 months ago

I can confirm that is the behavior I am seeing. Picture3

GenericNerd commented 7 months ago

I cannot confirm this behaviour from my side. It may be showing the order as returned by the API itself, which may be what is causing this to be out of order. Do your communities use phpVMS 5 or 7?

walkerairtrans commented 7 months ago

I cannot confirm this behaviour from my side. It may be showing the order as returned by the API itself, which may be what is causing this to be out of order. Do your communities use phpVMS 5 or 7?

It's the v5 API and it's direct cause is this in search.php $results[$index]['submitDate'] = date(DATE_RFC3339, strtotime($result['submitDate']));

JSON dump from your app when calling the API request:

[{"id":259096,"submitDate":"2024-01-20T21:59:06+00:00","airlineCode":"WAE","number":"1417","route":"LIMF KUK7L KUKEV MOLUS GILIR UN853 IBERA N853 DIK M624 BUB Y28 HELEN HELE2A EHAM","diverted":0,"diverticao":"","distance":628,"flightType":"P","departureAirport":"LIMF","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":2.02,"landingRate":-176,"fuelUsed":10873},{"id":259029,"submitDate":"2024-01-20T19:34:45+00:00","airlineCode":"WAE","number":"7997","route":"EHAM LOPI4E LOPIK N852 LNO SUTAL UN852 GTQ UZ343 BEGAR N491 TRA N850 DEGAD Z424 AKASU AKAS2F LIMF","diverted":0,"diverticao":"","distance":534,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"LIMF","aircraft":24,"status":"Accepted","flightTime":1.88,"landingRate":-215,"fuelUsed":7937},{"id":258962,"submitDate":"2024-01-20T17:16:18+00:00","airlineCode":"WAE","number":"1660","route":"EDDM GIVM6Q GIVMI Y101 IBAGA MASEK L604 BIGGE T281 NORKU NORK2A EHAM","diverted":0,"diverticao":"","distance":417,"flightType":"P","departureAirport":"EDDM","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":1.75,"landingRate":-320,"fuelUsed":6793},{"id":258890,"submitDate":"2024-01-20T14:30:28+00:00","airlineCode":"WAE","number":"5505","route":"EHAM REND2E EDUPO Z739 MISGO DOJOH DODEN TABUM HAREM T104 ROKIL ROKI1A EDDM","diverted":0,"diverticao":"","distance":465,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"EDDM","aircraft":24,"status":"Accepted","flightTime":1.73,"landingRate":-83,"fuelUsed":6953},{"id":258592,"submitDate":"2024-01-19T19:39:11+00:00","airlineCode":"WAE","number":"547","route":"LIPZ ROKI8X ROKIB Z468 EKPEB BRENO KONIN M726 MAH ASPAT MASEK L604 BIGGE T281 NORKU NORK2A EHAM","diverted":0,"diverticao":"","distance":591,"flightType":"P","departureAirport":"LIPZ","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":2.2800000000000002,"landingRate":-272,"fuelUsed":9892},{"id":258504,"submitDate":"2024-01-19T15:37:26+00:00","airlineCode":"WAE","number":"7731","route":"EHAM LOPI3S LOPIK N852 SUTAL UN852 GTQ UZ343 BEGAR ELMUR RESIA P131 ADOSA L612 ALBET ALBE2E LIPZ","diverted":0,"diverticao":"","distance":662,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"LIPZ","aircraft":24,"status":"Accepted","flightTime":2.55,"landingRate":-429,"fuelUsed":8753},{"id":258471,"submitDate":"2024-01-19T13:12:58+00:00","airlineCode":"WAE","number":"1574","route":"LOWG MILG5U MILGO LAMSI L604 BIGGE T281 NORKU NORK2A EHAM","diverted":0,"diverticao":"","distance":552,"flightType":"P","departureAirport":"LOWG","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":2.2199999999999998,"landingRate":-286,"fuelUsed":8708},{"id":258216,"submitDate":"2024-01-18T18:33:54+00:00","airlineCode":"WAE","number":"5611","route":"EHAM REND2S EDUPO Z739 MISGO PODIP BOMBI T104 HAREM Z74 LAMPU Z54 NOMBO Y161 MAH L173 EBEDA L603 LATLO OBEDI LEOBE LEOB1M LOWG","diverted":0,"diverticao":"","distance":590,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"LOWG","aircraft":24,"status":"Accepted","flightTime":1.98,"landingRate":-73,"fuelUsed":7771},{"id":258067,"submitDate":"2024-01-18T04:47:23+00:00","airlineCode":"WAE","number":"5485","route":"ESKN TONS3L TONSA N850 NEMBA MAXEL N850 ELSOB N125 EEL EEL1A EHAM","diverted":0,"diverticao":"","distance":618,"flightType":"P","departureAirport":"ESKN","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":2.02,"landingRate":-191,"fuelUsed":9748},{"id":258033,"submitDate":"2024-01-18T02:19:32+00:00","airlineCode":"WAE","number":"8641","route":"EHAM SPY4V ANDIK N873 DETSO L734 GIMLO GIML2S ESKN","diverted":0,"diverticao":"","distance":683,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"ESKN","aircraft":24,"status":"Accepted","flightTime":2.4299999999999997,"landingRate":-225,"fuelUsed":8877},{"id":258000,"submitDate":"2024-01-17T23:53:56+00:00","airlineCode":"WAE","number":"7423","route":"EDDC ABKI3W ABKIS Z715 PEROX L602 SODRO KATCE NORKU NORK2A EHAM","diverted":0,"diverticao":"","distance":414,"flightType":"P","departureAirport":"EDDC","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":1.72,"landingRate":-65,"fuelUsed":726},{"id":257857,"submitDate":"2024-01-17T16:38:52+00:00","airlineCode":"WAE","number":"5379","route":"EHAM ARNE4E ARNEM L620 HMM NOMKA SUVUT L620 BESIP Q240 DRN EDDC","diverted":0,"diverticao":"","distance":464,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"EDDC","aircraft":174,"status":"Accepted","flightTime":1.75,"landingRate":-413,"fuelUsed":7302},{"id":257701,"submitDate":"2024-01-17T02:37:49+00:00","airlineCode":"WAE","number":"4449","route":"EGPE GUSSI NESDI N560 ERSON TLA L602 ERKIT N110 DOLAS L603 LAMSO LAMS2A EHAM","diverted":0,"diverticao":"","distance":516,"flightType":"P","departureAirport":"EGPE","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":2.2,"landingRate":-86,"fuelUsed":7696},{"id":257591,"submitDate":"2024-01-16T20:52:49+00:00","airlineCode":"FDX","number":"3486","route":"KMEM JTEEE5 ODATE FTZ TRTLL6 KORD","diverted":0,"diverticao":"","distance":500,"flightType":"C","departureAirport":"KMEM","arrivalAirport":"KORD","aircraft":103,"status":"Accepted","flightTime":1.87,"landingRate":-315,"fuelUsed":16977},{"id":253037,"submitDate":"2024-01-05T12:31:16+00:00","airlineCode":"FDX","number":"1048","route":"PANC JOH J501 YAK NCA10 MITOM YQU J515 YEG Q862 OMROD GUDOG YYN ISN KP12Y KP90A KP78C TURCK MCI WHOLL BRBBQ3 KMEM","diverted":0,"diverticao":"","distance":2765,"flightType":"C","departureAirport":"PANC","arrivalAirport":"KMEM","aircraft":103,"status":"Accepted","flightTime":6.52,"landingRate":-188,"fuelUsed":76318},{"id":252706,"submitDate":"2024-01-04T14:32:45+00:00","airlineCode":"FDX","number":"1313","route":"RJAA GULBO2 GULBO Y808 NOLAX Y812 ADNAP R591 ADGOR AGEDI AKISU ASPIN AAMYY AMOND ALDOZ ALUFF SPY CHUUK EHM HAMND NEELL6 PANC","diverted":0,"diverticao":"","distance":3131,"flightType":"C","departureAirport":"RJAA","arrivalAirport":"PANC","aircraft":103,"status":"Accepted","flightTime":7.3,"landingRate":-174,"fuelUsed":81518},{"id":251655,"submitDate":"2024-01-01T20:02:06+00:00","airlineCode":"WAC","number":"394","route":"RJNT UOZU2 HISUI Y31 SYOEN Y517 ESKAS Y303 ENTAK Y30 SWAMP SWAMPE RJAA","diverted":0,"diverticao":"","distance":353,"flightType":"C","departureAirport":"RJNT","arrivalAirport":"RJAA","aircraft":103,"status":"Accepted","flightTime":1.18,"landingRate":-275,"fuelUsed":12596},{"id":251388,"submitDate":"2024-01-01T01:55:17+00:00","airlineCode":"WAC","number":"1781","route":"RJOA KIJYY3 YME Y381 KMC Y45 OYABE MANYO RJNT","diverted":0,"diverticao":"","distance":296,"flightType":"C","departureAirport":"RJOA","arrivalAirport":"RJNT","aircraft":103,"status":"Accepted","flightTime":1.63,"landingRate":-168,"fuelUsed":12499},{"id":251301,"submitDate":"2023-12-31T22:18:41+00:00","airlineCode":"WAC","number":"2692","route":"ROAH KIZNA2 YUGAF AMAMI Y25 BOMAP Y45 MARCO V28 HGE HGE RJOA","diverted":0,"diverticao":"","distance":602,"flightType":"C","departureAirport":"ROAH","arrivalAirport":"RJOA","aircraft":103,"status":"Accepted","flightTime":2.02,"landingRate":-270,"fuelUsed":17351},{"id":251252,"submitDate":"2023-12-31T20:30:41+00:00","airlineCode":"WAC","number":"9026","route":"RJFT MIFNE1 MIFNE HKC Y45 ONC Y525 IHEYA IHEYAS ROAH","diverted":0,"diverticao":"","distance":472,"flightType":"C","departureAirport":"RJFT","arrivalAirport":"ROAH","aircraft":103,"status":"Accepted","flightTime":1.87,"landingRate":-277,"fuelUsed":18222},{"id":251198,"submitDate":"2023-12-31T18:42:28+00:00","airlineCode":"WAC","number":"960","route":"RJOO TIGER2 TIGER SUMAR AYAME SETOH ONOPA WASYU Y28 ONDOC Y452 OOITA Y40 KAZMA RJFT","diverted":0,"diverticao":"","distance":291,"flightType":"C","departureAirport":"RJOO","arrivalAirport":"RJFT","aircraft":103,"status":"Accepted","flightTime":1.23,"landingRate":-337,"fuelUsed":22511},{"id":251162,"submitDate":"2023-12-31T17:19:42+00:00","airlineCode":"FDX","number":"3527","route":"RJAA PIGOK2 PIGOK Y50 ELNIS Y564 IBENO Y56 TOHME Y54 KOHWA Y546 AGPUK MIRAI ABENO IKOMA RJOO","diverted":0,"diverticao":"","distance":361,"flightType":"C","departureAirport":"RJAA","arrivalAirport":"RJOO","aircraft":103,"status":"Accepted","flightTime":1.55,"landingRate":-310,"fuelUsed":15902},{"id":251004,"submitDate":"2023-12-31T04:23:13+00:00","airlineCode":"FDX","number":"1062","route":"KATL VARNM2 RESPE NOPOE MAUDD6 KSDF","diverted":0,"diverticao":"","distance":322,"flightType":"C","departureAirport":"KATL","arrivalAirport":"KSDF","aircraft":103,"status":"Accepted","flightTime":1.58,"landingRate":-292,"fuelUsed":13249},{"id":250974,"submitDate":"2023-12-31T02:46:07+00:00","airlineCode":"FDX","number":"1062","route":"KJAX BRSTL1 BAXLY LAIRI LARZZ JJEDI3 KATL","diverted":0,"diverticao":"","distance":353,"flightType":"C","departureAirport":"KJAX","arrivalAirport":"KATL","aircraft":103,"status":"Accepted","flightTime":1.38,"landingRate":-285,"fuelUsed":13054},{"id":250819,"submitDate":"2023-12-30T20:38:52+00:00","airlineCode":"FDX","number":"1455","route":"KMEM OLEMS6 LEYIK LDK DUCHY OHDEA1 KJAX","diverted":0,"diverticao":"","distance":537,"flightType":"C","departureAirport":"KMEM","arrivalAirport":"KJAX","aircraft":103,"status":"Accepted","flightTime":1.6800000000000002,"landingRate":-295,"fuelUsed":15467},{"id":250726,"submitDate":"2023-12-30T16:54:47+00:00","airlineCode":"FDX","number":"1282","route":"KAFW KUSSO1 FORCK ELD HOBRK3 KMEM","diverted":0,"diverticao":"","distance":443,"flightType":"C","departureAirport":"KAFW","arrivalAirport":"KMEM","aircraft":103,"status":"Accepted","flightTime":1.72,"landingRate":-351,"fuelUsed":14933},{"id":250675,"submitDate":"2023-12-30T14:57:31+00:00","airlineCode":"FDX","number":"2254","route":"KOAK OAK SYRAH JSICA Q130 PNH MDANO WESAT2 KAFW","diverted":0,"diverticao":"","distance":1301,"flightType":"C","departureAirport":"KOAK","arrivalAirport":"KAFW","aircraft":103,"status":"Accepted","flightTime":3.18,"landingRate":-297,"fuelUsed":32397},{"id":250449,"submitDate":"2023-12-29T22:18:54+00:00","airlineCode":"FDX","number":"5463","route":"KSAN PADRZ2 OROSZ COREZ RGOOD SKIZM2 KOAK","diverted":0,"diverticao":"","distance":431,"flightType":"C","departureAirport":"KSAN","arrivalAirport":"KOAK","aircraft":103,"status":"Accepted","flightTime":1.6800000000000002,"landingRate":-25,"fuelUsed":15606},{"id":250367,"submitDate":"2023-12-29T19:34:39+00:00","airlineCode":"WAX","number":"5783","route":"KLAS LAS V538 GFS V514 MZB KSAN","diverted":0,"diverticao":"","distance":259,"flightType":"P","departureAirport":"KLAS","arrivalAirport":"KSAN","aircraft":28,"status":"Accepted","flightTime":1.15,"landingRate":-72,"fuelUsed":860},{"id":250278,"submitDate":"2023-12-29T15:46:59+00:00","airlineCode":"WAX","number":"6825","route":"KTEX MMM KLAS","diverted":0,"diverticao":"","distance":395,"flightType":"P","departureAirport":"KTEX","arrivalAirport":"KLAS","aircraft":28,"status":"Accepted","flightTime":1.1,"landingRate":-259,"fuelUsed":1082},{"id":249985,"submitDate":"2023-12-28T18:06:33+00:00","airlineCode":"WAX","number":"7496","route":"KOKC OLGUY3 GRUVN ETL KTEX","diverted":0,"diverticao":"","distance":587,"flightType":"P","departureAirport":"KOKC","arrivalAirport":"KTEX","aircraft":33,"status":"Accepted","flightTime":3.0700000000000003,"landingRate":-161,"fuelUsed":1106},{"id":249750,"submitDate":"2023-12-28T00:32:56+00:00","airlineCode":"WAX","number":"5975","route":"KSAN ZZOOO3 IPL J18 SJN J74 TXO RUSTS GHOST3 KOKC","diverted":0,"diverticao":"","distance":1029,"flightType":"P","departureAirport":"KSAN","arrivalAirport":"KOKC","aircraft":33,"status":"Accepted","flightTime":4.22,"landingRate":-51,"fuelUsed":1458},{"id":249591,"submitDate":"2023-12-27T16:28:02+00:00","airlineCode":"WAX","number":"1554","route":"KJAC GEYSR6 DNW KICNE RACGO YADDY PAWLY IVEYY EED BARET5 KSAN","diverted":0,"diverticao":"","distance":807,"flightType":"P","departureAirport":"KJAC","arrivalAirport":"KSAN","aircraft":33,"status":"Accepted","flightTime":3,"landingRate":-39,"fuelUsed":1143},{"id":249369,"submitDate":"2023-12-26T21:53:34+00:00","airlineCode":"WAX","number":"5154","route":"KDEN ROCKI5 RLG CHE BPI JAC KJAC","diverted":0,"diverticao":"","distance":419,"flightType":"P","departureAirport":"KDEN","arrivalAirport":"KJAC","aircraft":33,"status":"Accepted","flightTime":1.13,"landingRate":-105,"fuelUsed":657},{"id":248858,"submitDate":"2023-12-25T01:23:04+00:00","airlineCode":"WAX","number":"5108","route":"KDAB ROYES7 CRG TAY MGM JILLS Q128 VEGUC GCK DANDD1 KDEN","diverted":0,"diverticao":"","distance":1384,"flightType":"P","departureAirport":"KDAB","arrivalAirport":"KDEN","aircraft":33,"status":"Accepted","flightTime":5.55,"landingRate":-39,"fuelUsed":2218},{"id":248770,"submitDate":"2023-12-24T19:10:20+00:00","airlineCode":"WAX","number":"7471","route":"KEYW CARNU KDAB","diverted":0,"diverticao":"","distance":295,"flightType":"P","departureAirport":"KEYW","arrivalAirport":"KDAB","aircraft":33,"status":"Accepted","flightTime":1.55,"landingRate":-99,"fuelUsed":544},{"id":248739,"submitDate":"2023-12-24T16:55:04+00:00","airlineCode":"WAX","number":"7852","route":"KSRQ SABEE KARTR KEYW","diverted":0,"diverticao":"","distance":204,"flightType":"P","departureAirport":"KSRQ","arrivalAirport":"KEYW","aircraft":33,"status":"Accepted","flightTime":1.6,"landingRate":-185,"fuelUsed":425},{"id":248596,"submitDate":"2023-12-24T02:51:28+00:00","airlineCode":"WAX","number":"9471","route":"KCRG OCF VARZE BREKR KSRQ","diverted":0,"diverticao":"","distance":238,"flightType":"P","departureAirport":"KCRG","arrivalAirport":"KSRQ","aircraft":33,"status":"Accepted","flightTime":1.03,"landingRate":-115,"fuelUsed":500},{"id":248479,"submitDate":"2023-12-23T20:27:42+00:00","airlineCode":"WAX","number":"5697","route":"KDCA JDUBB4 MELTN BASLE HOTAR1 KCRG","diverted":0,"diverticao":"","distance":591,"flightType":"P","departureAirport":"KDCA","arrivalAirport":"KCRG","aircraft":33,"status":"Accepted","flightTime":2.77,"landingRate":-74,"fuelUsed":1020},{"id":248106,"submitDate":"2023-12-22T17:35:26+00:00","airlineCode":"WAE","number":"3485","route":"EHAM BERG2S BERGI L602 SUPUR P1 ROKAN N96 EVTAR ADN EGPE","diverted":0,"diverticao":"","distance":475,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"EGPE","aircraft":24,"status":"Accepted","flightTime":2.2800000000000002,"landingRate":-524,"fuelUsed":9975},{"id":242706,"submitDate":"2023-12-04T20:22:44+00:00","airlineCode":"WAE","number":"8978","route":"ENCN RASV2A RASVI NAVIK TUSKA N873 JUIST P174 EEL EEL1A EHAM","diverted":0,"diverticao":"","distance":453,"flightType":"P","departureAirport":"ENCN","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":1.07,"landingRate":-398,"fuelUsed":6804},{"id":242631,"submitDate":"2023-12-04T14:56:15+00:00","airlineCode":"WAE","number":"2900","route":"EHAM ANDI2N ANDIK Z733 KONOM AMADA LANTI LANT2L ENCN","diverted":0,"diverticao":"","distance":388,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"ENCN","aircraft":24,"status":"Accepted","flightTime":1.05,"landingRate":-165,"fuelUsed":5996},{"id":241989,"submitDate":"2023-12-02T20:35:45+00:00","airlineCode":"WAE","number":"4946","route":"EDDB SUKI1N SUKIP Y206 BUREL P203 HLZ L980 AMSAN T281 NORKU NORK2A EHAM","diverted":0,"diverticao":"","distance":376,"flightType":"P","departureAirport":"EDDB","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":1.47,"landingRate":-361,"fuelUsed":6198},{"id":241892,"submitDate":"2023-12-02T16:26:49+00:00","airlineCode":"WAE","number":"4627","route":"EHAM ARN3SY ARNEM L620 SUVOX Z718 OSN BATEL T207 OGBER OGB25L EDDB","diverted":0,"diverticao":"","distance":368,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"EDDB","aircraft":24,"status":"Accepted","flightTime":1.18,"landingRate":-126,"fuelUsed":6399},{"id":241665,"submitDate":"2023-12-01T22:11:15+00:00","airlineCode":"WAE","number":"1032","route":"EGNT GIRL3X GIRLI P18 GASKO UY250 MAMUL L603 LAMSO LAMS2A EHAM","diverted":0,"diverticao":"","distance":386,"flightType":"P","departureAirport":"EGNT","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":1.05,"landingRate":-207,"fuelUsed":6755},{"id":241628,"submitDate":"2023-12-01T20:05:38+00:00","airlineCode":"WAE","number":"2940","route":"EHAM BERG3N BERGI L602 NALAX L46 ODNEK N110 ERKIT EGNT","diverted":0,"diverticao":"","distance":366,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"EGNT","aircraft":24,"status":"Accepted","flightTime":1.58,"landingRate":-122,"fuelUsed":7129},{"id":241152,"submitDate":"2023-11-30T00:31:53+00:00","airlineCode":"WAE","number":"1666","route":"LIML PEPA1J PEPAG N851 ROLSA LOKTA TEDGO HAREM LOHRE MAPOX NORKU NORK2A EHAM","diverted":0,"diverticao":"","distance":555,"flightType":"P","departureAirport":"LIML","arrivalAirport":"EHAM","aircraft":24,"status":"Accepted","flightTime":1.95,"landingRate":-361,"fuelUsed":8637},{"id":241079,"submitDate":"2023-11-29T19:23:22+00:00","airlineCode":"WAE","number":"5521","route":"EHAM REND2E EDUPO Z739 MISGO ASBON TUSUK KRH NATOR TRA RIPUS GERSA SOSON ODINA SRN2S LIML","diverted":0,"diverticao":"","distance":515,"flightType":"P","departureAirport":"EHAM","arrivalAirport":"LIML","aircraft":24,"status":"Accepted","flightTime":1.8199999999999998,"landingRate":-327,"fuelUsed":7983},{"id":240925,"submitDate":"2023-11-29T02:42:51+00:00","airlineCode":"WAX","number":"1501","route":"KATL JACCC2 KELLN Q56 KIWII WAVES CAPSS3 KDCA","diverted":0,"diverticao":"","distance":527,"flightType":"P","departureAirport":"KATL","arrivalAirport":"KDCA","aircraft":228,"status":"Accepted","flightTime":1.98,"landingRate":-132,"fuelUsed":6307},{"id":240535,"submitDate":"2023-11-27T19:34:46+00:00","airlineCode":"WAE","number":"7247","route":"","diverted":0,"diverticao":"","distance":190,"flightType":"P","departureAirport":"KLRD","arrivalAirport":"KAUS","aircraft":106,"status":"Accepted","flightTime":1.22,"landingRate":-56,"fuelUsed":108},{"id":240502,"submitDate":"2023-11-27T17:31:20+00:00","airlineCode":"WAE","number":"5634","route":"","diverted":0,"diverticao":"","distance":107,"flightType":"P","departureAirport":"KMFE","arrivalAirport":"KLRD","aircraft":106,"status":"Accepted","flightTime":1.12,"landingRate":-28,"fuelUsed":68},{"id":240494,"submitDate":"2023-11-27T16:49:33+00:00","airlineCode":"WAE","number":"861","route":"","diverted":0,"diverticao":"","distance":35,"flightType":"P","departureAirport":"KHRL","arrival Airport":"KMFE","aircraft":106,"status":"Accepted","flightTime":0.42,"landingRate":-58,"fuelUsed":21},{"id":240485,"submitDate":"2023-11-27T15:30:09+00:00","airlineCode":"WAE","number":"8950","route":"","diverted":0,"diverticao":"","distance":104,"flightType":"P","departureAirport":"KCRP","arrivalAirport":"KHRL","aircraft":106,"status":"Accepted","flightTime":0.12,"landingRate":-58,"fuelUsed":66},{"id":240473,"submitDate":"2023-11-27T14:42:41+00:00","airlineCode":"WAE","number":"9841","route":"","diverted":0,"diverticao":"","distance":183,"flightType":"P","departureAirport":"KGLS","arrivalAirport":"KCRP","aircraft":106,"status":"Accepted","flightTime":1.3,"landingRate":-125,"fuelUsed":124},{"id":240371,"submitDate":"2023-11-27T02:17:26+00:00","airlineCode":"WAE","number":"3419","route":"","diverted":0,"diverticao":"","distance":67,"flightType":"P","departureAirport":"KBPT","arrivalAirport":"KGLS","aircraft":106,"status":"Accepted","flightTime":0.78,"landingRate":-126,"fuelUsed":40}, {"id":240356,"submitDate":"2023-11-27T01:24:26+00:00","airlineCode":"WAE","number":"1031","route":"KHOU VUH V70 SBI KBPT","diverted":0,"diverticao":"","distance":83,"flightType":"P","departureAirport":"KHOU","arrivalAirport":"KBPT","aircraft":106,"status":"Accepted","flightTime":0.1,"landingRate":-53,"fuelUsed":52},{"id":239667,"submitDate":"2023-11-25T14:47:56+00:00","airlineCode":"WAT","number":"6023","route":"KLAS NIITZ3 SSKEE GUP KF33A DWINE FSM MEMFS HUTCC KNSAW RUSSA RUTTH CHPPR1 KATL","diverted":0,"diverticao":"","distance":1567,"flightType":"P","departureAirport":"KLAS","arrivalAirport":"KATL","aircraft":18,"status":"Accepted","flightTime":3.55,"landingRate":-245,"fuelUsed":33686},{"id":238115,"submitDate":"2023-11-20T15:14:37+00:00","airlineCode":"DAL","number":"877","route":"TXKF SHOLL ENAPI M325 OXANA AR8 OHPEA DOOGE FAM GCK CEZ TYEGR CHOWW2 KLAS","diverted":0,"diverticao":"","distance":2524,"flightType":"P","departureAirport":"TXKF","arrivalAirport":"KLAS","aircraft":18,"status":"Accepted","flightTime":6,"landingRate":-634,"fuelUsed":63080},{"id":237779,"submitDate":"2023-11-19T15:48:44+00:00","airlineCode":"DAL","number":"3552","route":"KJAX JAWSS BAHAA JAINS M326 JIMAC POPOP1 TXKF","diverted":0,"diverticao":"","distance":919,"flightType":"P","departureAirport":"KJAX","arrivalAirport":"TXKF","aircraft":18,"status":"Accepted","flightTime":2.18,"landingRate":-468,"fuelUsed":22806},{"id":236938,"submitDate":"2023-11-16T21:36:03+00:00","airlineCode":"DAL","number":"5964","route":"KBOS SSOXS6 SSOXS Q167 RIFLE HEADI Q97 SAWED GUILD Q409 SESUE ESENT LUNNI1 KJAX","diverted":0,"diverticao":"","distance":936,"flightType":"P","departureAirport":"KBOS","arrivalAirport":"KJAX","aircraft":5,"status":"Accepted","flightTime":2.95,"landingRate":-248,"fuelUsed":13385},{"id":236286,"submitDate":"2023-11-14T19:25:03+00:00","airlineCode":"DAL","number":"7184","route":"KPDX LAVAA6 PDT HLN J90 MLS KP06Y KP06C GOLLF KP03K SIKBO Q140 AHPAH JOSSY PONCT KBOS","diverted":0,"diverticao":"","distance":2262,"flightType":"P","departureAirport":"KPDX","arrivalAirport":"KBOS","aircraft":24,"status":"Accepted","flightTime":4.13,"landingRate":-261,"fuelUsed":22174},{"id":236194,"submitDate":"2023-11-14T13:17:19+00:00","airlineCode":"DAL","number":"5148","route":"KAUS ELOEL3 FORSS BOOMR KA36W MTJ KU75M JOTBA HHOOD4 KPDX","diverted":0,"diverticao":"","distance":1578,"flightType":"P","departureAirport":"KAUS","arrivalAirport":"KPDX","aircraft":24,"status":"Accepted","flightTime":5.27,"landingRate":-271,"fuelUsed":21565},{"id":235955,"submitDate":"2023-11-13T19:39:32+00:00","airlineCode":"DAL","number":"7973","route":"","diverted":0,"diverticao":"","distance":1460,"flightType":"P","departureAirport":"KJFK","arrivalAirport":"KAUS","aircraft":188,"status":"Accepted","flightTime":4.57,"landingRate":-225,"fuelUsed":36154},{"id":235900,"submitDate":"2023-11-12T21:19:52+00:00","airlineCode":"WAT","number":"2083","route":"KJAX CROSB2 WISPR JROSS LAANA Q109 DFENC SAWED Q97 DLAAY RADDS SIE CAMRN4 KJFK","diverted":0,"diverticao":"","distance":761,"flightType":"P","departureAirport":"KJAX","arrivalAirport":"KJFK","aircraft":18,"status":"Accepted","flightTime":2.62,"landingRate":-260,"fuelUsed":18940},{"id":232870,"submitDate":"2023-11-05T01:10:52+00:00","airlineCode":"WAE","number":"2584","route":"","diverted":0,"diverticao":"","distance":71,"flightType":"P","departureAirport":"KHOU","arrivalAirport":"KBPT","aircraft":106,"status":"Accepted","flightTime":0.88,"landingRate":-80,"fuelUsed":45},{"id":230670,"submitDate":"2023-10-28T21:29:39+00:00","airlineCode":"WAT","number":"7320","route":"TNCM MODOR2 ELOPO SALAB 15N055W 15N045W TUTLO 21N030W XIGLU NORED GDV UN871 SONSO MOGBA UH400 MAK UG850 FES UA411 ORSUP UZ888 DIMAO UW254 TISRI DTTA","diverted":0,"diverticao":"","distance":4417,"flightType":"P","departureAirport":"TNCM","arrivalAirport":"DTTA","aircraft":18,"status":"Accepted","flightTime":9.2,"landingRate":-568,"fuelUsed":111720},{"id":195834,"submitDate":"2023-06-11T21:50:36+00:00","airlineCode":"WAE","number":"5764","route":"ESSB TRS4W TRS M996 ROGMI ROGM2T ESSV","diverted":0,"diverticao":"","distance":120,"flightType":"P","departureAirport":"ESSB","arrivalAirport":"ESSV","aircraft":76,"status":"Accepted","flightTime":0.82,"landingRate":-68,"fuelUsed":283},{"id":195812,"submitDate":"2023-06-11T20:34:47+00:00","airlineCode":"DAL","number":"8678","route":"KJAX CROSB2 WISPR JROSS LCAPE Q87 GEARS BBOBO Q22 RBV Q419 JFK ROBUC3 KBOS","diverted":0,"diverticao":"","distance":909,"flightType":"P","departureAirport":"KJAX","arrivalAirport":"KBOS","aircraft":24,"status":"Accepted","flightTime":2.27,"landingRate":-349,"fuelUsed":11895},{"id":195533,"submitDate":"2023-06-10T21:32:07+00:00","airlineCode":"SIL","number":"3052","route":"KCMX FGHRN MADII7 KORD","diverted":0,"diverticao":"","distance":363,"flightType":"P","departureAirport":"KCMX","arrivalAirport":"KORD","aircraft":274,"status":"Accepted","flightTime":1.05,"landingRate":-180,"fuelUsed":2035},{"id":195403,"submitDate":"2023-06-10T12:44:40+00:00","airlineCode":"DAL","number":"7670","route":"KSRQ WILON HILIS TEBOW1 KJAX","diverted":0,"diverticao":"","distance":295,"flightType":"P","departureAirport":"KSRQ","arrivalAirport":"KJAX","aircraft":65,"status":"Accepted","flightTime":1.47,"landingRate":-251,"fuelUsed":2789},{"id":194435,"submitDate":"2023-06-06T19:41:36+00:00","airlineCode":"WAX","number":"6754","route":"KTEX ALS ELD CABLO HEVVN BANGZ1 KSRQ","diverted":0,"diverticao":"","distance":1507,"flightType":"P","departureAirport":"KTEX","arrivalAirport":"KSRQ","aircraft":107,"status":"Accepted","flightTime":3.82,"landingRate":-98,"fuelUsed":6618},{"id":194272,"submitDate":"2023-06-05T23:38:39+00:00","airlineCode":"WAX","number":"9368","route":"KATL NASSA2 CHOOK MUDHO Q128 FLOOD J28 HBU ETL KTEX","diverted":0,"diverticao":"","distance":1281,"flightType":"P","departureAirport":"KATL","arrivalAirport":"KTEX","aircraft":217,"status":"Accepted","flightTime":3.48,"landingRate":-131,"fuelUsed":7190},{"id":194136,"submitDate":"2023-06-05T13:40:08+00:00","airlineCode":"WAE","number":"3592","route":"YSSY TESAT V140 KAMBA W220 MATLA W347 ARM YARM","diverted":0,"diverticao":"","distance":217,"flightType":"P","departureAirport":"YSSY","arrivalAirport":"YARM","aircraft":76,"status":"Accepted","flightTime":1.47,"landingRate":-75,"fuelUsed":557},{"id":193957,"submitDate":"2023-06-04T20:00:45+00:00","airlineCode":"WAE","number":"4226","route":"EFHN XILAN ESSB","diverted":0,"diverticao":"","distance":180,"flightType":"P","departureAirport":"EFHN","arrivalAirport":"ESSB","aircraft":76,"status":"Accepted","flightTime":1.23,"landingRate":-56,"fuelUsed":426},{"id":193723,"submitDate":"2023-06-04T00:53:39+00:00","airlineCode":"WAE","number":"9576","route":"","diverted":0,"diverticao":"","distance":78,"flightType":"P","departureAirport":"EFHF","arrivalAirport":"EFHN","aircraft":76,"status":"Accepted","flightTime":0.63,"landingRate":-85,"fuelUsed":229},{"id":190832,"submitDate":"2023-05-22T11:39:42+00:00","airlineCode":"WAX","number":"4812","route":"THIS IS TEXT IN THE ROUTE BOX IN FLIGHT TRACKING","diverted":0,"diverticao":"","distance":15,"flightType":"P","departureAirport":"KJAX","arrivalAirport":"KCRG","aircraft":43,"status":"Accepted","flightTime":0.22,"landingRate":-168,"fuelUsed":9},{"id":190829,"submitDate":"2023-05-22T11:27:38+00:00","airlineCode":"WAX","number":"6580","route":"THIS IS TEXT IN THE ROUTE BOX IN MY FLIGHTS","diverted":0,"diverticao":"","distance":13,"flightType":"P","departureAirport":"KCRG","arrivalAirport":"KJAX","aircraft":43,"status":"Accepted","flightTime":0.2,"landingRate":-157,"fuelUsed":10},{"id":190008,"submitDate":"2023-05-19T19:57:27+00:00","airlineCode":"WAX","number":"5144","route":"","diverted":1,"diverticao":"KJAX","distance":13,"flightType":"P","departureAirport":"KCRG","arrivalAirport":"KJAX","aircraft":43,"status":"Diverted","flightTime":0.25,"landingRate":-137,"fuelUsed":9},{"id":189229,"submitDate":"2023-05-16T17:09:46+00:00","airlineCode":"WAE","number":"3888","route":"TJSJ ACONY3 SAPPO Y280 OCTAL ORL HAINY QUBEN1 KJAX","diverted":0,"diverticao":"","distance":1213,"flightType":"P","departureAirport":"TJSJ","arrivalAirport":"KJAX","aircraft":65,"status":"Accepted","flightTime":3.52,"landingRate":-335,"fuelUsed":9690},{"id":189071,"submitDate":"2023-05-15T23:31:38+00:00","airlineCode":"WAE","number":"1799","route":"KCLL BLUBL BLUBL4 KHOU","diverted":0,"diverticao":"","distance":102,"flightType":"P","departureAirport":"KCLL","arrivalAirport":"KHOU","aircraft":106,"status":"Accepted","flightTime":1.02,"landingRate":-92,"fuelUsed":60},{"id":187814,"submitDate":"2023-05-11T00:19:45+00:00","airlineCode":"WAE","number":"8679","route":"SBEG ISUNU UL322 TIM UA632 BGI UA555 ILURI A555 COY TJSJ","diverted":0,"diverticao":"","distance":1513,"flightType":"P","departureAirport":"SBEG","arrivalAirport":"TJSJ","aircraft":65,"status":"Accepted","flightTime":3.9699999999999998,"landingRate":-383,"fuelUsed":11353},{"id":187745,"submitDate":"2023-05-10T18:07:13+00:00","airlineCode":"WAE","number":"4763","route":"SBSJ KOTRU RPR POSVO UL304 MALMI UM423 OGTEM UL304 ESMAR IRUM1B SBEG","diverted":0,"diverticao":"","distance":1567,"flightType":"P","departureAirport":"SBSJ","arrivalAirport":"SBEG","aircraft":65,"status":"Accepted","flightTime":4.6,"landingRate":-395,"fuelUsed":13240},{"id":187271,"submitDate":"2023-05-08T18:03:57+00:00","airlineCode":"WAE","number":"4448","route":"KGRB MUMBY KCMX","diverted":0,"diverticao":"","distance":224,"flightType":"P","departureAirport":"KGRB","arrivalAirport":"KCMX","aircraft":274,"status":"Accepted","flightTime":1.42,"landingRate":-230,"fuelUsed":1314},{"id":187138,"submitDate":"2023-05-08T01:03:18+00:00","airlineCode":"WAE","number":"7017","route":"KMIA FOLZZ2 FOLZZ PADUS MYGF","diverted":0,"diverticao":"","distance":144,"flightType":"P","departureAirport":"KMIA","arrivalAirport":"MYGF","aircraft":33,"status":"Accepted","flightTime":1.15,"landingRate":-165,"fuelUsed":296},{"id":186817,"submitDate":"2023-05-07T00:39:28+00:00","airlineCode":"WAE","number":"234","route":"KGRK CONRA2 CLL KCLL","diverted":0,"diverticao":"","distance":90,"flightType":"P","departureAirport":"KGRK","arrivalAirport":"KCLL","aircraft":106,"status":"Accepted","flightTime":0.1,"landingRate":-49,"fuelUsed":58},{"id":186012,"submitDate":"2023-05-04T00:44:00+00:00","airlineCode":"WAE","number":"4302","route":"KORD PMPKN NEATO DLLAN RONIC BAE KGRB","diverted":0,"diverticao":"","distance":169,"flightType":"P","departureAirport":"KORD","arrivalAirport":"KGRB","aircraft":275,"status":"Accepted","flightTime":1.27,"landingRate":-148,"fuelUsed":1199},{"id":185354,"submitDate":"2023-05-01T16:56:57+00:00","airlineCode":"WAT","number":"9622","route":"TNCM N0472F360 PJM B520 LARPP Y318 DONQU Y185 MANLE Q89 SHRKS LAIRI LARZZ JJEDI3 KATL","diverted":0,"diverticao":"","distance":1536,"flightType":"P","departureAirport":"TNCM","arrivalAirport":"KATL","aircraft":5,"status":"Accepted","flightTime":4.43,"landingRate":-166,"fuelUsed":22712},{"id":184800,"submitDate":"2023-04-30T02:47:40+00:00","airlineCode":"WAE","number":"4019","route":"KACT BOSEL KGRK","diverted":0,"diverticao":"","distance":75,"flightType":"P","departureAirport":"KACT","arrivalAirport":"KGRK","aircraft":106,"status":"Accepted","flightTime":0.77,"landingRate":-26,"fuelUsed":47},{"id":184790,"submitDate":"2023-04-30T02:03:56+00:00","airlineCode":"WAE","number":"7232","route":"","diverted":0,"diverticao":"","distance":158,"flightType":"P","departureAirport":"KGGG","arrivalAirport":"KACT","aircraft":106,"status":"Accepted","flightTime":1.55,"landingRate":-66,"fuelUsed":99},{"id":184690,"submitDate":"2023-04-29T19:27:15+00:00","airlineCode":"WAE","number":"1491","route":"KTXK DOGGE GGG KGGG","diverted":0,"diverticao":"","distance":117,"flightType":"P","departureAirport":"KTXK","arrivalAirport":"KGGG","aircraft":106,"status":"Accepted","flightTime":1.17,"landingRate":-68,"fuelUsed":67},{"id":182858,"submitDate":"2023-04-22T20:33:20+00:00","airlineCode":"WAE","number":"9295","route":"KDAL KUSSO1 KUSSO TRRCH TRYTN KTXK","diverted":0,"diverticao":"","distance":171,"flightType":"P","departureAirport":"KDAL","arrivalAirport":"KTXK","aircraft":106,"status":"Accepted","flightTime":1.17,"landingRate":-34,"fuelUsed":52},{"id":182631,"submitDate":"2023-04-22T00:45:51+00:00","airlineCode":"WAE","number":"1535","route":"KAFW ARILE KDAL","diverted":0,"diverticao":"","distance":27,"flightType":"P","departureAirport":"KAFW","arrivalAirport":"KDAL","aircraft":106,"status":"Accepted","flightTime":0.33,"landingRate":-48,"fuelUsed":18},{"id":182594,"submitDate":"2023-04-21T21:20:50+00:00","airlineCode":"WAE","number":"4122","route":"KSPS MOTZA WESAT2 KAFW","diverted":0,"diverticao":"","distance":110,"flightType":"P","departureAirport":"KSPS","arrivalAirport":"KAFW","aircraft":106,"status":"Accepted","flightTime":0.83,"landingRate":-8,"fuelUsed":22},{"id":182505,"submitDate":"2023-04-21T14:49:02+00:00","airlineCode":"WAE","number":"1553","route":"KAMA PNH V114 SPS KSPS","diverted":0,"diverticao":"","distance":192,"flightType":"P","departureAirport":"KAMA","arrivalAirport":"KSPS","aircraft":106,"status":"Accepted","flightTime":1.33,"landingRate":-14,"fuelUsed":113},{"id":181989,"submitDate":"2023-04-19T01:06:12+00:00","airlineCode":"WAX","number":"7749","route":"","diverted":0,"diverticao":"","distance":7,"flightType":"P","departureAirport":"KCRG","arrivalAirport":"KCRG","aircraft":43,"status":"Accepted","flightTime":0.33,"landingRate":-12,"fuelUsed":6},{"id":181984,"submitDate":"2023-04-19T00:39:06+00:00","airlineCode":"WAX","number":"7604","route":"","diverted":0,"diverticao":"","distance":15,"flightType":"P","departureAirport":"KCRG","arrivalAirport":"KCRG","aircraft":236,"status":"Accepted","flightTime":0.33,"landingRate":-311,"fuelUsed":126},{"id":181646,"submitDate":"2023-04-17T15:29:54+00:00","airlineCode":"WAT","number":"148","route":"KCLT KWEEN4 PITRW Y436 JAINS L451 IORIO FIPEK Y355 SLUGO PJM TNCM","diverted":0,"diverticao":"","distance":1509,"flightType":"P","departureAirport":"KCLT","arrivalAirport":"TNCM","aircraft":24,"status":"Accepted","flightTime":4,"landingRate":-90,"fuelUsed":3097},{"id":181521,"submitDate":"2023-04-17T00:02:21+00:00","airlineCode":"WAE","number":"377","route":"KLBB LBB V81 PNH KAMA","diverted":0,"diverticao":"","distance":119,"flightType":"P","departureAirport":"KLBB","arrivalAirport":"KAMA","aircraft":106,"status":"Accepted","flightTime":0.83,"landingRate":-60,"fuelUsed":79},{"id":181485,"submitDate":"2023-04-16T22:00:14+00:00","airlineCode":"WAT","number":"2557","route":"KORF COUPN CHSLY5 KCLT","diverted":0,"diverticao":"","distance":274,"flightType":"P","departureAirport":"KORF","arrivalAirport":"KCLT","aircraft":188,"status":"Accepted","flightTime":1.17,"landingRate":-65,"fuelUsed":35454},{"id":181222,"submitDate":"2023-04-16T01:42:31+00:00","airlineCode":"WAT","number":"3756","route":"KMCO VIZTA CAMJO Q109 PANDY BARTL J121 ISO DRONE KORF","diverted":0,"diverticao":"","distance":708,"flightType":"P","departureAirport":"KMCO","arrivalAirport":"KORF","aircraft":21,"status":"Accepted","flightTime":2,"landingRate":-361,"fuelUsed":2285}]

You can beautify that and see it's in the correct order.

I worked myself around the problem with simply this code: $results[$index]['submitDate'] = $results[$index]['submitDate'] . ' UTC';

smartcars3_DWZbH8GGoh

And before:

image

GenericNerd commented 7 months ago

Oh! Are you able to open this as a PR for me in the phpVMS 5 API repo? If not, I can add it in to the next API update.