Initial import for API part.

1 files changed, 62 insertions, 0 deletions

diff --git a/api/gen_firm.php b/api/gen_firm.php
new file mode 100644
index 0000000..8c08030
--- /dev/null
+++ b/api/gen_firm.php
@@ -0,0 +1,62 @@
+<?php
+/**
+ * Copyright 2016 Ludovic Pouzenc <ludovic@pouzenc.fr>
+ * Copyright 2016 Nicolas Goaziou <mail@nicolasgoaziou.fr>
+ * 
+ * This file is part of CHD Gestion.
+ * 
+ * CHD Gestion is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ * 
+ * CHD Gestion is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ * 
+ * You should have received a copy of the GNU General Public License
+ * along with CHD Gestion.  If not, see <http://www.gnu.org/licenses/>.
+**/
+
+include_once('inc/config.php');
+$mysqli = new mysqli($db_config['host'], $db_config['username'], $db_config['password'], $db_config['database']);
+unset($db_config);
+$mysqli->query("SET NAMES 'utf8'");
+
+$arg_ip4pub=(array_key_exists('ip4pub', $_GET) && preg_match('/^[0-9.]+$/', $_GET['ip4pub']))?$_GET['ip4pub']:NULL;
+
+if (!$arg_ip4pub) {
+	die("Wrong args");
+}
+$arg = $mysqli->real_escape_string($arg_ip4pub);
+$res = $mysqli->query("SELECT * FROM v_api_gen_firm WHERE ippublique_id='$arg'");
+//var_dump($query);
+
+if ( $res === FALSE ) {
+	die("Wrong query");
+}
+
+$row = $res->fetch_assoc();
+if ( ! is_array($row) ) {
+	die("No result");
+}
+$row2 = $res->fetch_assoc();
+if ( is_array($row2) ) {
+	die("Non unique result");
+}
+
+$fullname = (strlen($row['raison'])==0)?($row['prenom'] .  " " . $row['nom']):$row['raison'];
+
+$matches=array();
+$res = preg_match_all('/\b\p{L}/u', $fullname, $matches);
+if ( $res < 1 ) {
+	die("Pb re");
+}
+
+$row['initiales'] = implode($matches[0]);
+unset($row['prenom']);
+unset($row['nom']);
+unset($row['raison']);
+
+echo json_encode($row);