function update_collaborateur_interne($recherche)
{
$champs_collab = array('MNEMONIC' => 1, 'NOM' => 1, 'PRENOM' => 1, 'NOMJEUNEFILLE' => 0, 'CIVILITE' => 1, 'ETAT' => 0, 'ARCHIVE' => 0, 'TEL' => 0, 'PRT' => 1, 'EMAIL' => 0, 'EMAILAPSA' => 1, 'TAUNO' => 0);
$champs_interne = array('DTNAISSANCE' => 1, 'NSS' => 0, 'LIEUNAISSANCE' => 1, 'NATIONALITE' => 0, 'ADRESSE' => 1, 'ADRESSE2' => 0, 'CP' => 1, 'VILLE' => 1, 'FONCTION' => 0, 'STATUT' => 0, 'COEFF' => 0, 'POSITION' => 0, 'TYPECONTRAT' => 0, 'TYPEHORAIRE' => 0, 'DTENTREE' => 1, 'DTDEPART' => 0, 'REMUNFIXE' => 0, 'REMUNVAR' => 0, 'NOMBANQUE' => 0, 'PERIODEESSAI' => 0, 'PPE' => 0, 'TR' => 0, 'FACTURABLE' => 0, 'GSM' => 0, 'PEE' => 0, 'TREIZIEME' => 0, 'PRIME_ANCI' => 0, 'PART_VARI' => 0, 'FRAIS' => 0, 'IBAN' => 0, 'BIC' => 0);
$vars_collab = verif_champs($champs_collab, 'COL_');
$vars_specif = verif_champs($champs_interne, 'INT_');
if (is_array($vars_collab) && is_array($vars_specif)) {
$vars_collab['TAU_NO'] = $vars_collab['COL_TAUNO'];
$vars_specif['FCT_NO'] = $vars_specif['INT_FONCTION'];
unset($vars_collab['COL_TAUNO'], $vars_specif['INT_FONCTION']);
$query = "SELECT COL_MNEMONIC FROM COLLABORATEUR WHERE COL_MNEMONIC = '" . $vars_collab['COL_MNEMONIC'] . "' AND COL_NO !=" . $recherche;
$result = $GLOBALS['connexion']->query($query);
if ($result->num_rows != 0) {
return 'Mnémonique déjà utilisé pour un autre collaborateur';
} else {
$query = creer_update($vars_collab, 'COLLABORATEUR', "COL_NO = " . $recherche);
$GLOBALS['connexion']->query($query);
$query = creer_update($vars_specif, 'INTERNE', "COL_NO = " . $recherche);
$GLOBALS['connexion']->query($query);
$url = str_replace("modification", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $recherche . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
}
} else {
$erreur = is_string($vars_collab) ? $vars_collab . "\n" : '';
$erreur .= is_string($vars_specif) ? $vars_specif : '';
return $erreur;
}
header('Location:' . $url);
}
function update_entreprise($recherche)
{
if (!empty($_FILES['LOGO']['name'])) {
$dossier = 'image/';
$fichier = basename($_FILES['LOGO']['name']);
move_uploaded_file($_FILES['LOGO']['tmp_name'], $dossier . $fichier);
$_POST['LOGO'] = $dossier . $fichier;
} else {
if ($_POST['IMGENT'] != '') {
$_POST['LOGO'] = $_POST['IMGENT'];
}
}
if (!empty($_FILES['LOGOPIED']['name'])) {
$dossier = 'image/';
$fichier = basename($_FILES['LOGOPIED']['name']);
move_uploaded_file($_FILES['LOGOPIED']['tmp_name'], $dossier . $fichier);
$_POST['LOGOPIED'] = $dossier . $fichier;
} else {
if ($_POST['IMGPIE'] != '') {
$_POST['LOGOPIED'] = $_POST['IMGPIE'];
}
}
$champs = array('NOM' => 1, 'STATUT' => 1, 'ADRESSE' => 1, 'ADRESSE_2' => 0, 'CP' => 1, 'TEL' => 1, 'VILLE' => 1, 'CAPITAL' => 1, 'TVA_INTRA' => 1, 'RCS' => 1, 'SIRET' => 1, 'APE' => 1, 'SITE_WEB' => 0, 'LOGO' => 1, 'LOGOPIED' => 0);
$vars = verif_champs($champs, 'ENT_');
if (is_array($vars)) {
$query = creer_update($vars, 'ENTREPRISE', "ENT_NO=" . $recherche);
$GLOBALS['connexion']->query($query);
$url = str_replace("modification", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $recherche . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
} else {
return $vars;
}
header('Location:' . $url);
}
function ajout_collaborateur_interne()
{
$champs_collab = array('MNEMONIC' => 1, 'NOM' => 1, 'PRENOM' => 1, 'NOMJEUNEFILLE' => 0, 'CIVILITE' => 1, 'ETAT' => 0, 'TEL' => 0, 'PRT' => 1, 'EMAIL' => 0);
$champs_interne = array('DTNAISSANCE' => 1, 'NSS' => 0, 'LIEUNAISSANCE' => 1, 'NATIONALITE' => 0, 'ADRESSE' => 1, 'ADRESSE2' => 0, 'CP' => 1, 'VILLE' => 1, 'FONCTION' => 0, 'STATUT' => 0, 'COEFF' => 0, 'POSITION' => 0, 'TYPECONTRAT' => 0, 'TYPEHORAIRE' => 0, 'DTENTREE' => 1, 'DTDEPART' => 0, 'REMUNFIXE' => 0, 'REMUNVAR' => 0, 'NOMBANQUE' => 0, 'PERIODEESSAI' => 0, 'PPE' => 0, 'TR' => 0, 'FACTURABLE' => 0, 'GSM' => 0, 'PEE' => 0, 'TREIZIEME' => 0, 'PRIME_ANCI' => 0, 'PART_VARI' => 0, 'FRAIS' => 0, 'IBAN' => 0, 'BIC' => 0);
$vars_collab = verif_champs($champs_collab, 'COL_');
$vars_interne = verif_champs($champs_interne, 'INT_');
if (is_array($vars_collab) && is_array($vars_interne)) {
$vars_interne['FCT_NO'] = $vars_interne['INT_FONCTION'];
unset($vars_interne['INT_FONCTION']);
$query = "SELECT COL_MNEMONIC FROM COLLABORATEUR WHERE COL_MNEMONIC = '" . $vars_collab['COL_MNEMONIC'] . "'";
$result = $GLOBALS['connexion']->query($query);
if ($result->num_rows != 0) {
return 'Mnémonique déjà utilisé';
} else {
$vars_collab['COL_EMAILAPSA'] = $vars_collab['COL_MNEMONIC'] . '@apsaroke.fr';
$query = creer_insert($vars_collab, 'COLLABORATEUR');
$GLOBALS['connexion']->query($query);
// Récupération de l'ID collaborateur
$id = $GLOBALS['connexion']->insert_id;
$vars_interne['COL_NO'] = $GLOBALS['connexion']->insert_id;
$query = creer_insert($vars_interne, 'INTERNE');
$GLOBALS['connexion']->query($query);
$url = str_replace("ajout", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $id . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $id;
}
} else {
$erreur = is_string($vars_collab) ? $vars_collab . "\n" : '';
$erreur .= is_string($vars_interne) ? $vars_interne : '';
return $erreur;
}
header('Location:' . $url);
}
function update_projet($recherche)
{
$champs = array('CLIENT' => 1, 'NOM' => 1, 'CTF' => 0, 'CTC' => 0, 'DTDEBUT' => 1, 'DTFINPREVUE' => 0, 'NUMCMDE' => 1, 'NBJOURS' => 0, 'COL' => 0, 'DETAIL' => 1, 'SUIVIPAR' => 1, 'MODALITE' => 0, 'ARCHIVE' => 0, 'DTCLOTURE' => 0, 'NO' => 0);
$champ2 = array('MISNOM' => 1, 'MISNUMCMDE' => 1, 'MISDATECMDE' => 1, 'MISDTDEBUT' => 1, 'MISDTFIN' => 1, 'MISNBJOURS' => 0, 'MISFORFAIT' => 0, 'MISMONTFORFAIT' => 0, 'MISTJM' => 0, 'MISPA' => 0, 'MISNO' => 0, 'MISCOMMENTAIRE' => 0, 'MISORDRE' => 0, 'PRONO' => 0);
$vars = verif_champs($champs, 'PRO_');
if (is_array($vars)) {
$vars['CLI_NO'] = $vars['PRO_CLIENT'];
$vars['CTF_NO'] = $vars['PRO_CTF'];
$vars['CTC_NO'] = $vars['PRO_CTC'];
$vars['COL_NO'] = $vars['PRO_COL'];
unset($vars['PRO_CLIENT'], $vars['PRO_CTF'], $vars['PRO_CTC'], $vars['PRO_COL']);
$query = creer_update($vars, 'PROJET', 'PRO_NO=' . $recherche);
$GLOBALS['connexion']->query($query);
$var2 = verif_champs($champ2, '');
if (is_array($var2)) {
$var2['MIS_NOM'] = $var2['MISNOM'];
$var2['MIS_NUMCMDE'] = $var2['MISNUMCMDE'];
$var2['MIS_DATECMDE'] = $var2['MISDATECMDE'];
$var2['MIS_DTDEBUT'] = $var2['MISDTDEBUT'];
$var2['MIS_DTFIN'] = $var2['MISDTFIN'];
$var2['MIS_NBJOURS'] = $var2['MISNBJOURS'];
$var2['MIS_SUIVIPAR'] = $var2['MISSUIVIPAR'];
$var2['MIS_FORFAIT'] = $var2['MISFORFAIT'];
$var2['MIS_MONTFORFAIT'] = $var2['MISMONTFORFAIT'];
$var2['MIS_TJM'] = $var2['MISTJM'];
$var2['MIS_PA'] = $var2['MISPA'];
$var2['MIS_COMMENTAIRE'] = $var2['MISCOMMENTAIRE'];
$var2['PRO_NO'] = $var2['PRONO'];
$var2['MIS_ORDRE'] = $var2['MISORDRE'];
$idmission = $var2['MISNO'];
unset($var2['MISNO'], $var2['PRONO'], $var2['MISORDRE'], $var2['MISNOM'], $var2['MISNUMCMDE'], $var2['MISDATECMDE'], $var2['MISDTDEBUT'], $var2['MISDTFIN'], $var2['MISNBJOURS']);
unset($var2['MISSUIVIPAR'], $var2['MISFORFAIT'], $var2['MISMONTFORFAIT'], $var2['MISTJM'], $var2['MISPA'], $var2['MISCOMMENTAIRE']);
if ($idmission > 0) {
$query = creer_update($var2, 'MISSION', "MIS_NO=" . $idmission);
} else {
$var2['PRO_NO'] = $recherche;
$query = creer_insert($var2, 'MISSION');
}
$GLOBALS['connexion']->query($query);
$url = str_replace("modification", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $recherche . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
} else {
return $var2;
}
} else {
return $vars;
}
//header('Location:' . $url);
?>
<script>
document.location.href = '<?php
echo $url;
?>
';
</script>
<?php
}
function update_client($recherche)
{
$champs = array('CODE' => 1, 'NOM' => 1, 'ADRCOM_1' => 1, 'ADRCOM_2' => 0, 'CPCOM' => 1, 'VILLECOM' => 1, 'DTCREATION' => 1, 'NOMFAC' => 0, 'ADRFAC_1' => 0, 'ADRFAC_2' => 0, 'CPFAC' => 0, 'VILLEFAC' => 0, 'PAYS' => 0, 'CODE_FOUR' => 0);
$vars = verif_champs($champs, 'CLI_');
if (is_array($vars)) {
$vars['CLI_LOGO'] = 'client/images_clients/' . $vars['CLI_LOGO'];
$query = creer_update($vars, 'CLIENT', "CLI_NO=" . $recherche);
$GLOBALS['connexion']->query($query);
} else {
return $vars;
}
return '';
}
function update_modereglement($recherche)
{
$champs = array('CODE' => 1, 'LIBELLE' => 1);
$vars = verif_champs($champs, 'MOR_');
if (is_array($vars)) {
$query = creer_update($vars, 'MODEREGLEMENT', "MOR_NO=" . $recherche);
$GLOBALS['connexion']->query($query);
$url = str_replace("modification", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $recherche . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
} else {
return $vars;
}
header('Location:' . $url);
}
function update_fournisseur($recherche)
{
$champs = array('CODE' => 1, 'DTCREATION' => 1, 'NOM' => 1, 'ARCHIVE' => 0);
$vars = verif_champs($champs, 'FOU_');
if (is_array($vars)) {
$query = creer_update($vars, 'FOURNISSEUR', "FOU_NO=" . $recherche);
$GLOBALS['connexion']->query($query);
$url = str_replace("modification", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $recherche . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
} else {
return $vars;
}
header('Location:' . $url);
}
function update_banque($recherche)
{
$champs = array('NOM' => 1, 'CDE_BAN' => 1, 'CDE_GUI' => 1, 'NUM_CPT' => 1, 'RIB' => 1);
$vars = verif_champs($champs, 'BAN_');
if (is_array($vars)) {
$query = creer_update($vars, 'BANQUE', "BAN_NO=" . $recherche);
$GLOBALS['connexion']->query($query);
$url = str_replace("modification", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $recherche . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
} else {
return $vars;
}
header('Location:' . $url);
}
function update_fonction($recherche)
{
$champs = array('NOM' => 1);
$vars = verif_champs($champs, 'FCT_');
if (is_array($vars)) {
$query = creer_update($vars, 'FONCTION', "FCT_NO=" . $recherche);
$GLOBALS['connexion']->query($query);
$url = str_replace("modification", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $recherche . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
} else {
return $vars;
}
header('Location:' . $url);
}
function ajout_fournisseur()
{
$champs = array('CODE' => 1, 'DTCREATION' => 1, 'NOM' => 1, 'ARCHIVE' => 0);
$vars = verif_champs($champs, 'FOU_');
if (is_array($vars)) {
$query = creer_insert($vars, 'FOURNISSEUR');
$GLOBALS['connexion']->query($query);
$id = $GLOBALS['connexion']->insert_id;
$url = str_replace("ajout", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $id . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $id;
} else {
return $vars;
}
header('Location:' . $url);
}
function ajout_modereglement()
{
$champs = array('CODE' => 1, 'LIBELLE' => 1);
$vars = verif_champs($champs, 'MOR_');
if (is_array($vars)) {
$query = creer_insert($vars, 'MODEREGLEMENT');
$GLOBALS['connexion']->query($query);
$id = $GLOBALS['connexion']->insert_id;
$url = str_replace("ajout", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $id . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $id;
} else {
return $vars;
}
header('Location:' . $url);
}
function ajout_banque()
{
$champs = array('NOM' => 1, 'CDE_BAN' => 1, 'CDE_GUI' => 1, 'NUM_CPT' => 1, 'RIB' => 1);
$vars = verif_champs($champs, 'BAN_');
if (is_array($vars)) {
$query = creer_insert($vars, 'BANQUE');
$GLOBALS['connexion']->query($query);
$id = $GLOBALS['connexion']->insert_id;
$url = str_replace("ajout", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $id . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $id;
} else {
return $vars;
}
header('Location:' . $url);
}
function update_contact_client($recherche)
{
$champs = array('CLIENT' => 1, 'NOM' => 1, 'PRENOM' => 1, 'EMAIL' => 1, 'PRT' => 1, 'FONCTION' => 1, 'COMMENTAIRE' => 0, 'ARCHIVE' => 0);
$vars = verif_champs($champs, 'CTC_');
if (is_array($vars)) {
$vars['CLI_NO'] = $vars['CTC_CLIENT'];
$vars['FCT_NO'] = $vars['CTC_FONCTION'];
unset($vars['CTC_CLIENT'], $vars['CTC_FONCTION']);
$query = creer_update($vars, 'CONTACT_CLIENT', "CTC_NO=" . $recherche);
$GLOBALS['connexion']->query($query);
$url = str_replace("modification", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $recherche . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
} else {
return $vars;
}
header('Location:' . $url);
}
function ajout_projet()
{
$champs = array('CLIENT' => 1, 'NOM' => 1, 'CTF' => 0, 'CTC' => 0, 'DTDEBUT' => 1, 'DTFINPREVUE' => 0, 'NUMCMDE' => 1, 'NBJOURS' => 0, 'COL' => 1, 'DETAIL' => 1, 'SUIVIPAR' => 1, 'MODALITE' => 0);
$champ2 = array('MISNOM' => 1, 'MISNUMCMDE' => 1, 'MISDATECMDE' => 1, 'MISDTDEBUT' => 1, 'MISDTFIN' => 1, 'MISNBJOURS' => 0, 'MISFORFAIT' => 0, 'MISMONTFORFAIT' => 0, 'MISTJM' => 0, 'MISPA' => 0, 'MISCOMMENTAIRE' => 0);
$vars = verif_champs($champs, 'PRO_');
$var2 = verif_champs($champ2, '');
if (is_array($vars)) {
$vars['CLI_NO'] = $vars['PRO_CLIENT'];
$vars['CTF_NO'] = $vars['PRO_CTF'];
$vars['CTC_NO'] = $vars['PRO_CTC'];
$vars['COL_NO'] = $vars['PRO_COL'];
unset($vars['PRO_CLIENT'], $vars['PRO_CTF'], $vars['PRO_CTC'], $vars['PRO_COL']);
$query = creer_insert($vars, 'PROJET');
$GLOBALS['connexion']->query($query);
$id = $GLOBALS['connexion']->insert_id;
if ($id != null && $id > 0) {
$var2['PRO_NO'] = $id;
$var2['MIS_ORDRE'] = 1;
$var2['MIS_NOM'] = $var2['MISNOM'];
$var2['MIS_NUMCMDE'] = $var2['MISNUMCMDE'];
$var2['MIS_DATECMDE'] = $var2['MISDATECMDE'];
$var2['MIS_DTDEBUT'] = $var2['MISDTDEBUT'];
$var2['MIS_DTFIN'] = $var2['MISDTFIN'];
$var2['MIS_NBJOURS'] = $var2['MISNBJOURS'];
$var2['MIS_SUIVIPAR'] = $var2['MISSUIVIPAR'];
$var2['MIS_FORFAIT'] = $var2['MISFORFAIT'];
$var2['MIS_MONTFORFAIT'] = $var2['MISMONTFORFAIT'];
$var2['MIS_TJM'] = $var2['MISTJM'];
$var2['MIS_PA'] = $var2['MISPA'];
$var2['MIS_COMMENTAIRE'] = $var2['MISCOMMENTAIRE'];
unset($var2['MISNOM'], $var2['MISNUMCMDE'], $var2['MISDATECMDE'], $var2['MISDTDEBUT'], $var2['MISDTFIN'], $var2['MISNBJOURS']);
unset($var2['MISSUIVIPAR'], $var2['MISFORFAIT'], $var2['MISMONTFORFAIT'], $var2['MISTJM'], $var2['MISPA'], $var2['MISCOMMENTAIRE']);
$query = creer_insert($var2, 'MISSION');
$GLOBALS['connexion']->query($query);
}
$url = str_replace("ajout", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $id . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $id;
} else {
return $vars;
}
header('Location:' . $url);
}
function ajout_client()
{
$champs = array('CODE' => 1, 'NOM' => 1, 'ADRCOM_1' => 1, 'ADRCOM_2' => 0, 'CPCOM' => 1, 'VILLECOM' => 1, 'DTCREATION' => 1, 'NOMFAC' => 0, 'ADRFAC_1' => 0, 'ADRFAC_2' => 0, 'CPFAC' => 0, 'VILLEFAC' => 0, 'PAYS' => 0, 'CODE_FOUR' => 0);
$vars = verif_champs($champs, 'CLI_');
if (is_array($vars)) {
$vars['CLI_LOGO'] = 'client/images_clients/' . $vars['CLI_LOGO'];
$query = creer_insert($vars, 'CLIENT');
$GLOBALS['connexion']->query($query);
unset($_POST);
} else {
return $vars;
}
?>
<script>
$('#reponseInfoMessage').val('Mise à jour effectuée');
document.location.href = "affichage.php?type=client";
</script>
<?php
}
function update_libdocument($recherche)
{
$champs = array('DOCNO' => 1, 'ORDRE' => 1, 'NOMD' => 1, 'CONTENU' => 1, 'COL' => 0);
$vars = verif_champs($champs, 'LDO_');
if (is_array($vars)) {
$vars['DOC_NO'] = $vars['LDO_DOCNO'];
$vars['LDO_NOM'] = $vars['LDO_NOMD'];
$vars['COL_NO'] = $vars['LDO_COL'];
unset($vars['LDO_DOCNO'], $vars['LDO_COL'], $vars['LDO_NOMD']);
$query = creer_update($vars, 'LIBDOCUMENT', "LDO_NO=" . $recherche);
$GLOBALS['connexion']->query($query);
$url = str_replace("modifier", "recherche", $_POST['urlRetourMAJ']) . "?iddoc=" . $vars['DOC_NO'] . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
} else {
return $vars;
}
header('Location:' . $url);
}
function ajout_contact_fournisseur()
{
$champs = array('FOURNISSEUR' => 1, 'NOM' => 1, 'PRENOM' => 1, 'EMAIL' => 1, 'PRT' => 1, 'FONCTION' => 1, 'COMMENTAIRE' => 0, 'ARCHIVE' => 0);
$vars = verif_champs($champs, 'CTF_');
if (is_array($vars)) {
$vars['FOU_NO'] = $vars['CTF_FOURNISSEUR'];
$vars['FCT_NO'] = $vars['CTF_FONCTION'];
unset($vars['CTF_FOURNISSEUR'], $vars['CTF_FONCTION']);
$query = creer_insert($vars, 'CONTACT_FOURNISSEUR');
$GLOBALS['connexion']->query($query);
$id = $GLOBALS['connexion']->insert_id;
$url = str_replace("ajout", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $id . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $id;
} else {
return $vars;
}
header('Location:' . $url);
}
function update_collaborateur_externe($recherche)
{
$champs = array('FOURNISSEUR' => 1, 'NOM' => 1, 'PRENOM' => 1, 'ETAT' => 0, 'ARCHIVE' => 0, 'MNEMONIC' => 1, 'CIVILITE' => 1, 'NOMJEUNEFILLE' => 0, 'TEL' => 0, 'PRT' => 1, 'EMAIL' => 0);
$vars = verif_champs($champs, 'COL_');
if (is_array($vars)) {
//TODO : vérifier, il manque peut être un unset($vars['COL_NO']);
$externe = array('FOU_NO' => $vars['COL_FOURNISSEUR']);
unset($vars['COL_FOURNISSEUR']);
$query = creer_update($vars, 'COLLABORATEUR', 'COL_NO=' . $recherche);
$GLOBALS['connexion']->query($query);
$query = creer_update($externe, 'EXTERNE', 'COL_NO=' . $recherche);
$GLOBALS['connexion']->query($query);
$url = str_replace("modification", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $recherche . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $recherche;
} else {
return $vars;
}
header('Location:' . $url);
}
function ajout_collaborateur_externe()
{
$champs = array('FOURNISSEUR' => 1, 'NOM' => 1, 'PRENOM' => 1, 'ETAT' => 0, 'MNEMONIC' => 1, 'CIVILITE' => 1, 'NOMJEUNEFILLE' => 0, 'TEL' => 0, 'PRT' => 1, 'EMAIL' => 1);
$vars = verif_champs($champs, 'COL_');
if (is_array($vars)) {
$externe = array('FOU_NO' => $vars['COL_FOURNISSEUR']);
unset($vars['COL_FOURNISSEUR']);
$query = creer_insert($vars, 'COLLABORATEUR');
$GLOBALS['connexion']->query($query);
$externe['COL_NO'] = $GLOBALS['connexion']->insert_id;
$query = creer_insert($externe, 'EXTERNE');
$GLOBALS['connexion']->query($query);
$url = str_replace("ajout", "affichage", $_POST['urlRetourMAJ']) . "&recherche=" . $id . "&message=MAJOK";
unset($_POST);
$_POST['recherche'] = $id;
} else {
return $vars;
}
header('Location:' . $url);
}
<?php
include "inc/connection.php";
include_once 'inc/verif_champs_formulaire.php';
require_once 'calendrier/fonction_nbjoursMois.php';
include 'calendrier/fonction_nomMois.php';
//var_dump($_POST);
$champs = array('ENT_NO' => 1, 'BAN_NO' => 1, 'FAC_NUMCMDE' => 1, 'FAC_DEV' => 1, 'FAC_NOMCOM' => 1, 'FAC_DATE' => 1, 'FAC_PERIODE' => 1, 'FAC_NOMCLI' => 1, 'FAC_CODCLI' => 1, 'FAC_ADR1' => 1, 'FAC_ADR2' => 0, 'FAC_CP' => 1, 'FAC_VILLE' => 1, 'FAC_NOMCTC' => 1, 'FAC_CODFOU' => 0, 'FAC_NOMPRO' => 1, 'FAC_PRODETAIL' => 1, 'FAC_MODE_REG' => 1);
$vars = verif_champs($champs, '');
if (is_array($vars)) {
}
// Création d'un proforma
$COL_NO = $_POST['COL_NO'];
$CLI_NO = $_POST['CLI_NO'];
$FAC_CODFOU = $_POST['FAC_CODFOU'];
$PRO_NO = $_POST['PRO_NO'];
$CTC_NO = $_POST['CTC_NO'];
$FAC_SUIVIPAR = $_POST['FAC_SUIVIPAR'];
$FAC_ANNEE = $_POST['FAC_ANNEE'];
$FAC_MOIS = $_POST['FAC_MOIS'];
$FAC_TAUXTVA = $_POST['TAUX_TVA'];
$ENT_NO = $_POST['ENT_NO'];
$BAN_NO = $_POST['BAN_NO'];
$FAC_NUMCMDE = $_POST['FAC_NUMCMDE'];
$FAC_DEV = $_POST['FAC_DEV'];
$FAC_NOMCOM = $_POST['FAC_NOMCOM'];
$FAC_DATE = $_POST['FAC_DATE'];
$FAC_PERIODE = $_POST['FAC_PERIODE'];
$FAC_NOMCLI = $_POST['FAC_NOMCLI'];
$FAC_CODCLI = $_POST['FAC_CODCLI'];
$FAC_ADR1 = $_POST['FAC_ADR1'];
<?php
include 'inc/connection.php';
include_once 'inc/verif_champs_formulaire.php';
$champs = array('CODE' => 1, 'DTCREATION' => 1, 'NOM' => 1, 'NOMFAC' => 0, 'ADRCOM_1' => 1, 'ADRCOM_2' => 0, 'CPCOM' => 1, 'VILLECOM' => 1, 'ADRFAC_1' => 0, 'ADRFAC_2' => 0, 'CPFAC' => 0, 'VILLEFAC' => 0, 'PAYS' => 0, 'CODE_FOUR' => 0);
$vars = verif_champs($champs, 'CLI_');
if (is_array($vars)) {
$code = $vars['CLI_CODE'];
$nom = $vars['CLI_NOM'];
$adrcom1 = $vars['CLI_ADRCOM_1'];
$adrcom2 = $vars['CLI_ADRCOM_2'];
$cpcom = $vars['CLI_CPCOM'];
$villecom = $vars['CLI_VILLECOM'];
$date_creation = $vars['CLI_DTCREATION'];
$nom_facturation = $vars['CLI_NOMFAC'];
$adrfac1 = $vars['CLI_ADRFAC_1'];
$adrfac2 = $vars['CLI_ADRFAC_2'];
$cpfac = $vars['CLI_CPFAC'];
$villefac = $vars['CLI_VILLEFAC'];
$pays = $vars['CLI_PAYS'];
$codefourn = $vars['CLI_CODE_FOUR'];
$archive = $vars['CLI_ARCHIVE'];
$logo = "";
if (!empty($_FILES['LOGO']['name'])) {
$dossier = 'client/images_clients/';
$fichier = basename($_FILES['LOGO']['name']);
move_uploaded_file($_FILES['LOGO']['tmp_name'], $dossier . $fichier);
$logo = $dossier . $fichier;
} else {
$logo = '';
}
<?php
require "inc/verif_session.php";
include 'inc/creer_input.php';
include 'inc/liste.php';
include 'inc/verif_champs_formulaire.php';
include 'inc/suppression_donnees.php';
include 'inc/liste_categorie.php';
$page = array('titre' => 'Supprimer ', 'message' => '');
if (isset($_GET['type']) && isset($GLOBALS['liste_categorie'][$_GET['type']])) {
if (!empty($_POST)) {
$var = verif_champs(array('ID' => 1));
$type = $_GET['type'];
if (is_array($var)) {
call_user_func('supprimer_' . $type, $var['ID']);
unset($_POST);
} else {
$page['message'] = $var;
}
}
$nom = $GLOBALS['titre_fichier'][$_GET['type']];
$prefixe = $GLOBALS['liste_categorie'][$_GET['type']];
$page['titre'] .= $nom;
$page['contenu'] = select('Sélectionnez un ' . $nom, 'ID', donner_liste($_GET['type'], $prefixe), 2, 2);
} else {
$page['contenu'] = '';
$page['message'] = 'Type de suppression manquant';
}
include 'inc/page_suppression.php';
