7 Replies Latest reply on Jun 1, 2017 9:53 PM by scha-2 RSS
    scha-2 Explorer

    Help me Please.. About NaN

    Retrieves data from the database

    If the longitude value is 0, the previous GPS value is obtained.

    If the longitude value is not 0 in the database, the distance is obtained

    However, if the longitude value is 0, it is output as NaN

    and GPSvalue was obtain when longitude value is 0

    but distance is not obtain when longitude value is 0

    why? i don't know... T^T

    Help me.. Thanks...

     

    and attach my code

    var params = {

    datetime: w /* DATETIME */,

    cdma_number: me.cdma_number /* STRING */

    };            // result: INFOTABLE dataShape: TruckDataFeildDataShape

    var TruckData = Things["GetTruckDateFromPostgreDB"].GetTruckData(params);

     

     

    var params = {

      oldestFirst: true /* BOOLEAN */,

      maxItems: undefined /* NUMBER */,

      endDate: undefined /* DATETIME */,

      query: undefined /* QUERY */,

      startDate: w /* DATETIME */

    };

     

     

    // result: INFOTABLE dataShape: "undefined"

    var AAA = me.QueryPropertyHistory(params);

     

     

    var pre = AAA.getRow(0);

     

     

    var GPS = new Object();

    var params = {

    datetime: TruckData.kst_datetime /* DATETIME */,

    cdma_number: "01088948133" /* STRING */

    };

    // result: INFOTABLE dataShape: TruckDataFeildDataShape

    var preEntry = Things["GetTruckDateFromPostgreDB"].CompareTruckData(params);

    var PGPS = new Object();

    if(preEntry.latitude ==0){

    PGPS=pre.GPS;

    }

    else{

    PGPS.latitude = parseInt(preEntry.latitude/100)+(preEntry.latitude - parseInt(preEntry.latitude/100)*100)/60;

    PGPS.longitude= parseInt(preEntry.longitude/100)+(preEntry.longitude - parseInt(preEntry.longitude/100)*100)/60;

    PGPS.elevation = 0;

    PGPS.units = "WGS84";

    }

    if(TruckData.latitude ==0){

    GPS = PGPS}

    else{

    GPS.latitude = parseInt(TruckData.latitude/100)+(TruckData.latitude - parseInt(TruckData.latitude/100)*100)/60;

    GPS.longitude= parseInt(TruckData.longitude/100)+(TruckData.longitude - parseInt(TruckData.longitude/100)*100)/60;

    GPS.elevation = 0;

    GPS.units = "WGS84";

    }

    // distanceBetween(loc1:LOCATION,loc2:LOCATION,units:STRING):NUMBER

     

     

    // distanceBetween(loc1:LOCATION,loc2:LOCATION,units:STRING):NUMBER

    var difference = distanceBetween(GPS, PGPS, "");