6.9 KiB
Executable File
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(), }