function initialize($installed)
{
$defaults = $installed . '/Defaults';
# conf
if (!is_dir("conf")) {
mkdir("conf");
}
copy($defaults . "/conf/saunter.inc.default", "conf/settings.inc.default");
copy($defaults . "/conf/saucelabs.inc.default", "conf/saucelabs.inc.default");
copy($defaults . "/phpunit.xml", "phpunit.xml");
reinitialize($installed);
if (!is_dir("scripts")) {
mkdir("scripts");
}
if (!is_dir("includes")) {
mkdir("includes");
}
if (!is_dir("includes/pages")) {
mkdir("includes/pages");
}
if (!is_dir("includes/providers")) {
mkdir("includes/providers");
}
if (!is_dir("includes/tailored")) {
mkdir("includes/tailored");
}
if (!is_dir("logs")) {
mkdir("logs");
}
}
function enterdata($edit)
{
//echo "entering data";
$nomvalue = strtoupper($_POST['txt_Nom']);
$prenomvalue = strtoupper($_POST['txt_Prenom']);
$prenomvalue = strtr($prenomvalue, utf8_decode('àáâãäçèéêëìíîïñòóôõöùúûüýÿÀÁÂÃÄÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝ'), 'aaaaaceeeeiiiinooooouuuuyyAAAAACEEEEIIIINOOOOOUUUUY');
$_POST['chk_status'] = isset($_POST['chk_status']) ? 1 : 0;
$_POST['txt_Notahiti'] == '' ? $notahiti = 'NULL' : ($notahiti = $_POST['txt_Notahiti']);
//$status='TRUE';
$Mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
if ($edit == 0) {
//new insert
$query = "INSERT INTO `" . DB . "`.`mandataires` (`mandataireid`," . " `mandataireprefix`, `mandataireRS`," . " `mandatairestatus`, `mandatairenom`," . " `mandataireprenom`, `mandataireidtresor`, `mandataireemail`, `mandatairenotahiti`, `mandataireRC`," . " `mandatairetelephone`,`mandatairetelephone2`, `mandatairefax`, `mandatairebp`," . " `mandatairecp`, `mandataireville`, `mandatairecommune`, `mandatairepays`, `aroa`, `quartier`, `mandatairerib`,`obs`)" . " VALUES (NULL, '" . $_POST['box_Prefix'] . "', '" . strtoupper($_POST['txt_RS']) . "', '" . $_POST['chk_status'] . "', '" . strtoupper($_POST['txt_Nom']) . "', '" . strtoupper($_POST['txt_Prenom']) . "', '" . $_POST['txt_IDTresor'] . "', '" . strtolower($_POST['txt_Email']) . "', '" . $notahiti . "', '" . $_POST['txt_RC'] . "', '" . $_POST['txt_Telephone'] . "', '" . $_POST['txt_Telephone2'] . "', '" . $_POST['txt_Fax'] . "', '" . $_POST['txt_BP'] . "', '" . $_POST['txt_CP'] . "', '" . addslashes(strtoupper($_POST['txt_Ville'])) . "', '" . addslashes(strtoupper($_POST['txt_Commune'])) . "', '" . strtoupper($_POST['txt_Pays']) . "', '" . addslashes(strtoupper($_POST['txt_Commune'])) . "', '" . addslashes(strtoupper($_POST['txt_Pays'])) . "', '" . $_POST['txt_RIB'] . "', '" . addslashes($_POST['txt_obs']) . "')";
//echo $query;
$Mysqli->query($query);
$lastid = $Mysqli->insert_id;
if ($Mysqli->affected_rows > 0) {
reinitialize();
header("Location:mandataires.php?edit={$lastid}&success=1");
} else {
header("Location:mandataires.php?edit={$edit}&success=0");
}
} else {
//update
$query = "UPDATE `" . DB . "`.`mandataires` SET `mandatairestatus`='" . $_POST['chk_status'] . "', `mandataireprefix`='" . $_POST['box_Prefix'] . "', `mandataireRS`='" . strtoupper($_POST['txt_RS']) . "', `mandatairenom`='" . strtoupper($_POST['txt_Nom']) . "', `mandataireprenom`='" . strtoupper($_POST['txt_Prenom']) . "', `mandataireidtresor`='" . $_POST['txt_IDTresor'] . "', `mandataireemail`='" . strtolower($_POST['txt_Email']) . "', `mandatairenotahiti`='" . $notahiti . "', `mandataireRC`='" . $_POST['txt_RC'] . "', `mandatairetelephone`='" . $_POST['txt_Telephone'] . "', `mandatairetelephone2`='" . $_POST['txt_Telephone2'] . "', `mandatairefax`='" . $_POST['txt_Fax'] . "', `mandatairebp`='" . $_POST['txt_BP'] . "', `mandatairecp`='" . $_POST['txt_CP'] . "', `mandataireville`='" . addslashes(strtoupper($_POST['txt_Ville'])) . "', `mandatairecommune`='" . addslashes(strtoupper($_POST['txt_Commune'])) . "', `mandatairepays`='" . strtoupper($_POST['txt_Pays']) . "', `aroa`='" . addslashes(strtoupper($_POST['txt_Aroa'])) . "', `quartier`='" . addslashes(strtoupper($_POST['txt_Quartier'])) . "', `mandatairerib`='" . $_POST['txt_RIB'] . "', `obs`='" . addslashes($_POST['txt_obs']) . "'" . " WHERE `mandataireid`=" . $edit;
//echo $query;
$Mysqli->query($query);
if ($Mysqli->affected_rows > 0) {
reinitialize();
header("Location:mandataires.php?edit={$edit}&success=1");
} else {
header("Location:mandataires.php?edit={$edit}&success=0");
}
}
}
function enterdata($edit)
{
//echo "entering data";
//$_POST['chk_status'] = (isset($_POST['chk_status']) ? 1 : 0);
//$_POST['chk_principal'] = (isset($_POST['chk_principal']) ? 1 : 0);
if ($_POST['chk_principal']) {
unsetPrimaryHome($_POST['box_Proprietaire']);
} else {
$primary_home_count = checkPrimaryHome($_POST['box_Proprietaire'], $edit);
//echo $primary_home_count;
if ($primary_home_count == 0) {
$_POST['chk_principal'] = 1;
}
}
//$status='TRUE';
$mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
if ($edit == 0) {
//new insert
$query = "INSERT INTO `" . DB . "`.`lieux` (" . "`lieuid` , `lieustatus` , `lieuprincipal` ," . "`lieuproprietaire` , `lieumandataire` ," . "`lieulocataire` , `lieucategorie` ," . "`lieunomlieu` , `lieusurface` ," . "`lieunmaison` , `lieuservitude` ," . "`lieuquartier` ,`lieufacturer` ," . "`lieuedt` ,`lieucompteur` ," . "`lieuobservations`)" . " VALUES (NULL, '" . $_POST['chk_status'] . "', '" . $_POST['chk_principal'] . "', '" . $_POST['box_Proprietaire'] . "', '" . $_POST['box_Mandataire'] . "', '" . $_POST['box_Locataire'] . "', '" . $_POST['box_Categorie'] . "', '" . ucwords($_POST['txt_Nomlieu']) . "', '" . $_POST['txt_Surface'] . "', '" . $_POST['txt_Nmaison'] . "', '" . $_POST['box_Servitude'] . "', '" . $_POST['box_Quartier'] . "', '" . $_POST['box_Facturer'] . "', '" . strtoupper($_POST['txt_Compteur']) . "', '" . strtoupper($_POST['txt_EDT']) . "', '" . $_POST['txt_Observations'] . "')";
} else {
//update
$query = "UPDATE `" . DB . "`.`lieux` SET `lieustatus`='" . $_POST['chk_status'] . "', `lieuprincipal`='" . $_POST['chk_principal'] . "', `lieuproprietaire`='" . $_POST['box_Proprietaire'] . "', `lieumandataire`='" . $_POST['box_Mandataire'] . "', `lieulocataire`='" . $_POST['box_Locataire'] . "', `lieucategorie`='" . $_POST['box_Categorie'] . "',`lieunomlieu`='" . ucwords($_POST['txt_Nomlieu']) . "', `lieusurface`='" . $_POST['txt_Surface'] . "', `lieunmaison`='" . $_POST['txt_Nmaison'] . "', `lieuservitude`='" . $_POST['box_Servitude'] . "', `lieuquartier`='" . $_POST['box_Quartier'] . "', `lieufacturer`='" . $_POST['box_Facturer'] . "', `lieucompteur`='" . strtoupper($_POST['txt_Compteur']) . "', `lieuedt`='" . strtoupper($_POST['txt_EDT']) . "', `lieuobservations`='" . $_POST['txt_Observations'] . "'" . " WHERE `lieuid`='" . $edit . "'";
}
//echo $query;
$mysqli->query($query);
$affectedrows = $mysqli->affected_rows;
$mysqli->close();
if ($affectedrows > 0) {
reinitialize();
header("Location:lieux.php?edit={$edit}&success=1");
} else {
header("Location:lieux.php?edit={$edit}&success=0");
}
}
function enterdata($edit)
{
$nomvalue = strtoupper($_POST['txt_Nom']);
$nomvalue = strtr($nomvalue, utf8_decode('àáâãäçèéêëìíîïñòóôõöùúûüýÿÀÁÂÃÄÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝ'), 'AAAAACEEEEIIIINOOOOOUUUUYAAAAACEEEEIIIINOOOOOUUUUY');
$nomvalue = str_replace(' ', '', $nomvalue);
$nomvalue = str_replace('-', '', $nomvalue);
$prenomvalue = strtoupper($_POST['txt_Prenom']);
$prenomvalue = strtr($prenomvalue, utf8_decode('àáâãäçèéêëìíîïñòóôõöùúûüýÿÀÁÂÃÄÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝ'), 'AAAAACEEEEIIIINOOOOOUUUUYAAAAACEEEEIIIINOOOOOUUUUY');
$prenomvalue = str_replace(' ', '', $prenomvalue);
$prenomvalue = str_replace('-', '', $prenomvalue);
$dnvalue = $_POST['txt_DateNaissance'];
$nomvalue .= "000";
$nomvalue = substr($nomvalue, 0, 3);
$prenomvalue .= "0000000";
$prenomvalue = substr($prenomvalue, 0, 7);
$date = explode("/", $dnvalue);
$generatedcode = $date[2] . $date[1] . $date[0] . $nomvalue . $prenomvalue;
$dnvalue = $date[2] . "-" . $date[1] . "-" . $date[0];
$_POST['chk_status'] = isset($_POST['chk_status']) ? 1 : 0;
$Mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
if ($edit == 0) {
//new insert
$query = "INSERT INTO `" . DB . "`.`clients` (`clientid`, `clientcode`," . " `clientstatus`, `clientcivilite`, `clientnom`, `clientnommarital`," . " `clientprenom`, `clientprenom2`, `clientdatenaissance`," . " `clientlieunaissance`, `clientidtresor`, `clientemail`," . " `clientcps`, `clienttelephone`, `clientfax`, `clientbp`," . " `clientcp`, `clientville`, `clientcommune`, `clientpays`, `aroa`, `quartier`, `clientrib`, `obs`)" . " VALUES (NULL, '" . $generatedcode . "', '" . $_POST['chk_status'] . "', '" . $_POST['box_Civilite'] . "', '" . strtoupper($_POST['txt_Nom']) . "', '" . strtoupper($_POST['txt_NomMarital']) . "', '" . strtoupper($_POST['txt_Prenom']) . "', '" . strtoupper($_POST['txt_Prenom2']) . "', '" . $dnvalue . "', '" . strtoupper($_POST['txt_LieuNaissance']) . "', '" . $_POST['txt_IDTresor'] . "', '" . strtolower($_POST['txt_Email']) . "', '" . $_POST['txt_CPS'] . "', '" . $_POST['txt_Telephone'] . "', '" . $_POST['txt_Fax'] . "', '" . $_POST['txt_BP'] . "', '" . $_POST['txt_CP'] . "', '" . addslashes(strtoupper($_POST['txt_Ville'])) . "', '" . addslashes(strtoupper($_POST['txt_Commune'])) . "', '" . strtoupper($_POST['txt_Pays']) . "', '" . addslashes(strtoupper($_POST['txt_Aroa'])) . "', '" . addslashes(strtoupper($_POST['txt_Quartier'])) . "', '" . $_POST['txt_RIB'] . "', '" . addslashes($_POST['txt_obs']) . "');";
$Mysqli->query($query);
$lastid = $Mysqli->insert_id;
//print $query;
if ($Mysqli->affected_rows > 0) {
reinitialize();
header("Location:clients.php?edit={$lastid}&success=1&reset=1");
} else {
header("Location:clients.php?edit={$edit}&success=0");
}
} else {
//update
$query = "UPDATE `" . DB . "`.`clients` SET `clientcode`='" . $generatedcode . "'," . " `clientstatus`='" . $_POST['chk_status'] . "', `clientcivilite`='" . $_POST['box_Civilite'] . "', `clientnom`='" . strtoupper($_POST['txt_Nom']) . "', `clientnommarital`='" . strtoupper($_POST['txt_NomMarital']) . "', `clientprenom`='" . htmlentities(strtoupper($_POST['txt_Prenom']), ENT_QUOTES, 'UTF-8') . "', `clientprenom2`='" . strtoupper($_POST['txt_Prenom2']) . "', `clientdatenaissance`='" . $dnvalue . "'," . " `clientlieunaissance`='" . strtoupper($_POST['txt_LieuNaissance']) . "', `clientidtresor`='" . $_POST['txt_IDTresor'] . "', `clientemail`='" . strtolower($_POST['txt_Email']) . "', `clientcps`='" . $_POST['txt_CPS'] . "', `clienttelephone`='" . $_POST['txt_Telephone'] . "', `clientfax`='" . $_POST['txt_Fax'] . "', `clientbp`='" . $_POST['txt_BP'] . "', `clientcp`='" . $_POST['txt_CP'] . "', `clientville`='" . addslashes(strtoupper($_POST['txt_Ville'])) . "', `clientcommune`='" . addslashes(strtoupper($_POST['txt_Commune'])) . "', `clientpays`='" . strtoupper($_POST['txt_Pays']) . "', `aroa`='" . addslashes(strtoupper($_POST['txt_Aroa'])) . "', `quartier`='" . addslashes(strtoupper($_POST['txt_Quartier'])) . "', `clientrib`='" . $_POST['txt_RIB'] . "', `obs`='" . addslashes($_POST['txt_obs']) . "'" . " WHERE `clientid`=" . $edit;
$Mysqli->query($query);
//if ($Mysqli->affected_rows > 0){
reinitialize();
header("Location:clients.php?edit={$edit}&success=1&reset=1");
//} else {
// header("Location:clients.php?edit=$edit&success=0");
//}
}
}
