<?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']);
if (mysqli_connect_errno()) {
	die(mysqli_connect_error());
}
unset($db_config);
$mysqli->set_charset("utf8") or die($mysqli->error);

$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);