Link Client and Driver Request

[ViviTurtle]

1a) Driver passes a Call to update their status that in need of Client
1b) Client request a list of Driver under 30 minutes at a 0.5-2 second rate
2b) Systems chooses nearest Driver which changes Driver AND Client status to "INROT" (In Route)
2a) Drivers checks in 0.5-2 second intervals to see if their progress has been changed to find a client
...

[ViviTurtle]

Stored Procedure is done:

SP_CHANGE_2_LFCLT(, <CURRENT_LONGITUDE> , <CURRENT_LATITUDE>)

@changes user's status to (Looking for Client) as well as update their current locations
@can check if success with rowCount()
@returns void

Ex. CALL SP_CHANGE_2_LFCLT('ViviTurtle', 24.23156 , 103.25123);

---

SP_GET_DRIV_LFJOB();

@returns a table of Drivers with the following schema:
USERNAME
FNAME
LNAME
PRIM_PHONE
SEC_PHONE
CURRENT_LONGITUDE
CURRENT_LATITUDE

Ex. CALL SP_GET_DRIV_LFJOB();
**Note no parameters

---

SP_LINK_USER(<DRIVER_ID>, <CLIENT_ID>, <CLIENT_LONGITUDE>, <CLIENT_LATITUDE>, <DRIVER_LONGITUDE>,<DRIVER_LATITUDE> )

@Removes user from list of drivers that are looking for clients
@Creates a new Transanction under the In Progress status
@returns new Transanction_ID of the new transanction in transanction table as TRANS_ID

Ex. CALL SP_LINK_USER(1, 2, 23.52315, 23.25123, 103.23123, 13.23123);

---

SP_CHECK_IF_CHOSEN()

@returns 1 if status has been changed (In Route) else 0 in a column: IS_CHOSEN

Ex. CALL SP_CHECK_IF_CHOSEN('ViviTurtle')