/** * Created by PhpStorm. * User: Rascafr * Date: 02/12/2015 * Time: 01:39 */ function getPointsAPI($api_id, $track_id) { define("PATH", "/home/sites/francoisle.fr/public_html/wdidy/"); $cause = ''; $done = 0; $data = array(); // Get database include_once PATH . 'include/sql.php'; // Get other models include_once PATH . 'api/model/api/checkAPIKey.php'; // check API key include_once PATH . 'api/model/track/checkTrackID.php'; // check Track ID // Search for a valid API ID if (checkAPIKey($api_id) == 1) { // Search for a valid track if (checkTrackID($track_id) == 1) { // Search for all user tracks $req = $bdd->prepare("SELECT * FROM `wdidy-point` WHERE (`IDtrack` = ?)"); $req->execute(array($track_id)); $data = $req->fetchAll(); $req->closeCursor(); $done = 1; } else { $cause = 'Track inexistante'; } } else { $cause = 'Clé API inexistante ou désactivée'; } // Resulting array $resp['success'] = $done; $resp['cause'] = $cause; $resp['data'] = $data; return $resp; }
/** * Permet d'ajouter un point dans la track sélectionnée * @param $api_id : la clé d'API à utiliser * @param $track_id : track_id : l'identifiant de la track concernée * @param $latitude : la longitude en format double : 47.142563 * @param $longitude : la latitude en format double : -0.2547 * @param $date_point : la date du point en format YYYY-MM-JJ HH:MM:SS * @param $address : l'adresse du point en tant que chaîne de caractère */ function addPointAPI($api_id, $track_id, $latitude, $longitude, $date_point, $address) { define("PATH", "/home/sites/francoisle.fr/public_html/wdidy/"); $cause = ''; $done = 0; $data = array(); // Get database include_once PATH . 'include/sql.php'; // Get other models include_once PATH . 'api/model/api/checkAPIKey.php'; // check API key include_once PATH . 'api/model/track/checkTrackID.php'; // check Track ID // Skip return line $address = str_replace("\n", ", ", $address); // Search for a valid API ID if (checkAPIKey($api_id) == 1) { // Search for a valid track if (checkTrackID($track_id) == 1) { // Add the point into database $req = $bdd->prepare("INSERT INTO `wdidy-point`(`IDtrack`, `lat`, `lon`, `datetime`, `address`) VALUES (?,?,?,?,?)"); $req->execute(array($track_id, $latitude, $longitude, $date_point, $address)); $req->closeCursor(); // TODO Check whether the point has been added to the database // End date $req = $bdd->prepare("UPDATE `wdidy-track` SET `end` = ? WHERE `IDtrack` = ?"); $req->execute(array($date_point, $track_id)); $req->closeCursor(); $done = 1; } else { $cause = 'Track inexistante'; } } else { $cause = 'Clé API inexistante ou désactivée'; } // Resulting array $resp['success'] = $done; $resp['cause'] = $cause; $resp['data'] = $data; return $resp; }