# ALL API
## ERROR
HTTP CODE: 500
{
  "meta": {
    "code": "500",
    "message": "......",
  },
  "data": ""
}
## IF x-api-key not provided
HTTP CODE: 200
{
  "meta": {
    "code": "401",
    "message": "......",
  },
  "data": ""
}



# API LOGIN
## INPUT NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422",
    "message": "......",
  },
  "data": ""
}
## ACCOUNT NOT FOUND
HTTP CODE: 200
{
  "meta": {
    "code": "404_1",
    "message": "......",
  },
  "data": ""
}
## CANNOT LOGIN, ACCOUNT IS USED BY ANOTHER PHONE
HTTP CODE: 200
{
  "meta": {
    "code": "400_2",
    "message": "......",
  },
  "data": ""
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": {}
}



# API PROFILE
## ACCOUNT NOT FOUND
HTTP CODE: 200
{
  "meta": {
    "code": "404",
    "message": "......",
  },
  "data": ""
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": {}
}



# API LOGOUT
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": ""
}



# API LIST ACTIVE JOBS
## NO ACTIVE ORDER
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": []
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": []
}



# API DETAIL ACTIVE JOBS
## INPUT NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422",
    "message": "......",
  },
  "data": ""
}
## DETAIL ID NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422_1",
    "message": "......",
  },
  "data": ""
}
## JOB NOT FOUND
HTTP CODE: 200
{
  "meta": {
    "code": "404_4",
    "message": "......",
  },
  "data": ""
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": {}
}



# API ARRIVED PICKUP(sampai dilokasi muat) && PROCESS PICKUP(mulai memuat barang) && FINISH PICKUP(selesai memuat) && TRAVEL DOCUMENT(dokumen perjalanan) && OTW DROP(up photo per 2jam) && ARRIVED DROP(tiba dilokasi bongkar) && PROCESS DROP(proses bongkar) && FINISH DROP(selesai bongkar) && HANDOVER DOCUMENT(dokumen serah terima) && ACCIDENTS(kecelakaan)
## INPUT NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422",
    "message": "......",
  },
  "data": ""
}
## DETAIL ID NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422_1",
    "message": "......",
  },
  "data": ""
}
## TYPE UP PHOTO NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422_2",
    "message": "......",
  },
  "data": ""
}
## JOB NOT FOUND
HTTP CODE: 200
{
  "meta": {
    "code": "404_4",
    "message": "......",
  },
  "data": ""
}
## FAIL UP PHOTO
HTTP CODE: 200
{
  "meta": {
    "code": "400_1",
    "message": "......",
  },
  "data": ""
}
## NOT INSIZE PICKUP ZONE
HTTP CODE: 200
{
  "meta": {
    "code": "400_2",
    "message": "......",
  },
  "data": ""
}
## NOT INSIDE DROP ZONE
HTTP CODE: 200
{
  "meta": {
    "code": "400_3",
    "message": "......",
  },
  "data": ""
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": {}
}



# API LOCK MENU OTW DROP(No.4)
## INPUT NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422",
    "message": "......",
  },
  "data": ""
}
## DETAIL ID NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422_1",
    "message": "......",
  },
  "data": ""
}
## TYPE LOCK MENU NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422_2",
    "message": "......",
  },
  "data": ""
}
## JOB NOT FOUND
HTTP CODE: 200
{
  "meta": {
    "code": "404_4",
    "message": "......",
  },
  "data": ""
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": {}
}



# API LIST LOGBOOKS
## NO LIST LOGBOOKS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": []
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": []
}



# API DETAIL LOGBOOK
## INPUT NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422",
    "message": "......",
  },
  "data": ""
}
## LOGBOOK NOT FOUND
HTTP CODE: 200
{
  "meta": {
    "code": "404_4",
    "message": "......",
  },
  "data": ""
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": {}
}



# API INS ORDER LOGBOOK
## INPUT NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422",
    "message": "......",
  },
  "data": ""
}
## DETAIL ID NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422_1",
    "message": "......",
  },
  "data": ""
}
## JOB NOT FOUND
HTTP CODE: 200
{
  "meta": {
    "code": "404_4",
    "message": "......",
  },
  "data": ""
}
## LOGBOOK NOT FOUND
HTTP CODE: 200
{
  "meta": {
    "code": "404_5",
    "message": "......",
  },
  "data": ""
}
## FAIL UP PHOTO
HTTP CODE: 200
{
  "meta": {
    "code": "400_1",
    "message": "......",
  },
  "data": ""
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": ""
}



# API LIST ORDERS LOGBOOKS
## NO LIST LOGBOOKS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": []
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": []
}



# API DETAIL ORDERS LOGBOOK
## INPUT NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422",
    "message": "......",
  },
  "data": ""
}
## LOGBOOK NOT FOUND
HTTP CODE: 200
{
  "meta": {
    "code": "404_4",
    "message": "......",
  },
  "data": ""
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": {}
}



# API RUNNING BACKGROUND UP LOCATION DATA (1 MINUTES)
## INPUT NOT VALID
HTTP CODE: 200
{
  "meta": {
    "code": "422",
    "message": "......",
  },
  "data": ""
}
## SUCCESS
HTTP CODE: 200
{
  "meta": {
    "code": "200",
    "message": "......",
  },
  "data": ""
}

# TOKEN PA AGUS
eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJjaXBoZXJUZXh0IjoiVTJGc2RHVmtYMThVZTN6ZjVGRUpmVnJ1ak5FMHYyaVpEaGRUODVFclc0NU8vUW8rSFlhUlJhN2tFZlFjL3dzMUt6ZEgzbkd5WDdDd2hhS3FWRHljSmQ4bGN0TUs3RnZUVzJpM2FVWlFqekR3dVZXeUZWamgzZStjWDQ3S2xRWGciLCJpYXQiOjE2NjI2OTM1NzYsImF1ZCI6Ik1PQklMRSIsImlzcyI6IkJJTkdDT1JQIiwic3ViIjoiQVBQX0RSSVZFUiJ9.Cwqw-6iz-1jiNmT5QaTdxG-es1oe4EcnJ7prWpFxbI8

# EXPORT DATA
SELECT tr.id,drv.fullname,tr.crt_d_format,tr.crt_s_format,tr.latitude,tr.longitude,addr.fulladdress FROM db_trucking_dev.t_gps_tracks as tr
LEFT JOIN db_trucking_dev.t_gps_tracks_address as addr ON tr.id = addr.master_id
INNER JOIN db_trucking_dev.t_drivers as drv ON tr.drv_id = drv.id
WHERE tr.drv_id IN (37,39,40,41,42,43,44,45,46,47,51)
AND crt_s BETWEEN 1663779600 AND 1663952399
ORDER BY tr.id DESC;

# TEST ZONE BOUNDARY CONTAIN
SELECT
ST_Distance_Sphere( ST_GeomFromText('POINT(106.7634814 -6.2746089)'), z.boundary_points) AS distance_meters
,MBRContains( z.boundary_points, ST_GeomFromText('POINT(106.7634814 -6.2746089)') ) as is_contain
,MBRWithin( ST_GeomFromText('POINT(106.7634814 -6.2746089)'), z.boundary_points ) as is_within

# UNIX DARI SERVER DAN MOBILE BERBEDA ?
abc = {
  sec: moment().unix(),
  milisec: moment().valueOf(),
}